Kbase P60480: How to use idxfix to scan records for missing index entries ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/12/2009 |
|
Status: Verified
GOAL:
How to use idxfix to scan records for missing index entries ?
GOAL:
How do I know when idxfix has successfully finished scanning records for missing entries ?
FACT(s) (Environment):
UNIX
Windows
Progress 9.x
OpenEdge 10.x
FIX:
The idxfix utility can be run on or off line using proutil (example proutil sports -C idxfix ).
When started you choose from the menu option 2. Scan records for missing index entries
Then choose which indexes you want checked.
You are asked to confirm your selection and have the option to scan all records or start from a certain recid.
When the scanning has finished it will say 'Record scan complete' so many keys read.
Example:
Scan the database records for missing keys.
Phase 1, processing block number 256 in area 11. (8365)
Phase 1, processing block number 512 in area 11. (8365)
Record scan complete: 27940 keys read.
2 indexes, 642 blocks, 27940 keys checked.
If more than one index is being scanned there is no indication of where one index scan ends and another starts. If any missing entries were encountered the following message will be displayed:
Index fix made n index changes. (4975)