Kbase P49800: How to use the IDXFIX utility?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/04/2006 |
|
Status: Verified
GOAL:
How to use the proutil Idxfix utility?
GOAL:
How to scan the index entries for corruption?
FIX:
1. Execute the below command to bring up the Index Fix Utility.
proutil dbname -C idxfix
Index Fix Utility
1. Scan records for missing index entries.
2. Scan indexes for invalid index entries.
3. Both 1 and 2 above.
4. Cross-reference check of multiple indexes for a table.
5. Build indexes from existing indexes.
6. Delete one record and it's index entries.
7. Quit.
3. Choose option 3 to Scan for Missing Index entries and invalid entries.
4. At the prompt choose to scan "All" of the indices or "Some" of the Indices by entering the word "some" or "all".
5. Enter "Y" to validate recids for index entries.
6. Enter "Y" to fix indices on the Scan or "n" to not fix the indices and just perform a scan.
7. When asked to "Provide a range of records to scan through". Type "All" at the prompt.
8. Answer "Y" to the question "Is this correct? (y
)" to start the scan and fix of the indices.