Kbase P69097: How to use Progress Idxfix to scan one record at a time.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/01/2005 |
|
Status: Unverified
GOAL:
How to use Progress Idxfix to scan one record at a time.
GOAL:
How to repair corrupt indexes for a small amount of tables using Idxfix
FIX:
Progress Proutil utility allows indexes to be repaired while the database is online.
Proutil sports -C idxfix
1. Choose option 1 from the main menu:
Scan records for missing index entries
2. Select All from the next menu:
All - Check on all indexes
3. Select y for Fix indexes on Scan.
4. Enter the RECID for the table with the corrupt index when asked to provide a range of records to scan through.
5. Then either enter another RECID for to use an an endpoint or return to scan only one record. This allows a selection of narrow range of records to scan or to scan one record at a time using RECIDs
6. Select the area where the RECID(s) are located: Type the area for the recid(s)
The scan process scans the database records for missing keys and displays a message of how many indexes scanned.
"121 indexes, 1 block, 10 keys checked"
"Index fix completed successfully"