The idxfix option to proutil has many uses. One of these being the diagnosis of index level corruption. Output from this command will be displayed to the screen, but should also be redirected to a file for additional review by Progress Technical Support staff, in case rebuilding the indexes does not resolve the problem. This option to proutil can be run while the database is being accessed by other processes.
Syntax: proutil dbname -C idxfix | tee idxfix.out
From the Index Fix Utility main menu - select option 3. This option performs option 1 and 2 which are : 1. Scan records for missing index entries. 2. Scan indexes for invalid index entries. After making this selection you will need to process through the prompts to indicate if you will be checking all indexes or some indexes. Upon completion of running this command, the output will be captured in the file idxfix.out which was identified when you initiated the command. This output is useful in identifying if the database has index corruption. If corruption is found, the next step would be to fix the corruption, either by rebuilding the indexes offline with idxbuild or via this utility. |
