Hello People,

I have got a requirement to count the number of duplicate alternate Indexes present in a C-ISAM/IDXFORMAT(8) file.

Is there any utility that can furnish this information for the file? I am in need of the Alternate Index value and the number of times it appears as Alternate Index.
Eg:
AI_KEY1 1
AI_KEY2 5
AI_KEY3 2

Currently we are running a query on the file (in cyberquery tool) and calculating the count. But it takes long time to execute owing to the size of the file.
Please let me know for any relative informations.

Thanks for your help!!!

If I understand your requirement correctly, the following should work.

cut -d\  -f1 your_file_name | sort | uniq -c

Thanks. I'll give it a try and let you know if it fits the bill.

Btwn, I have two questions.
1. The file is an indexed file. If i run this command on the DAT part, it will work. Right? (I'll take care of the delimiter and field position in your command)
2. The file is of huge size. (>4 GB). Will this command lock the file when it is run? or is it just a READ mode operation.

Thanks much for your support!!!

The rebuild command automatically picks up the Alternate key/primary key location. (after completing, in the info summery it says whether there is any duplicate primary/alternate key).

But in the cut command we have to manually specify it.

Is there any derivative of rebuild command which gives the number of alternate key value?

Thanks for your help in advance!!!