Kbase P60276: How to use idxfix to scan for invalid index entries ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/12/2009 |
|
Status: Verified
GOAL:
How to use idxfix to scan for invalid index entries ?
GOAL:
How do I know when idxfix has successfully finished scanning indexes for invalid 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 indexes for invalid index entries
Then choose which indexes you want checked.
You are asked to confirm your selection and have the option to fix indexes during the scan. When the scanning has finished with one index you'll see it move to the next index. At the end you'll see a printed line stating the number of indexes and keys checked. Example:
When scanning indexes for invalid entries the following display will appear:
Index 22 (PUB.OrderLine, orderline): 10000 keys.
Index 22 (PUB.OrderLine, orderline): 13970 keys.
Index 23 (PUB.OrderLine, itemnum): 10000 keys.
Index 23 (PUB.OrderLine, itemnum): 13970 keys.
2 indexes, 27940 keys checked.