Kbase P7650: How to activate an inactive index.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/17/2009 |
|
Status: Verified
GOAL:
How to activate an inactive index.
GOAL:
How to activate an inactive primary unique index?
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
Progress 9.x
OpenEdge 10.x
FIX:
To activate an inactive index, whether primary unique or not, do an index rebuild as per the following steps:
1. Warning: Make sure you have a valid backup of your database in case this index build procedure fails for any reason.
2. Shut down the database.
3. Disable after-imaging using the command: rfutil sports2000 -C aimage end.
4. Start index rebuild using the command: proutil <dbname> -C idxbuild
5. A menu will appear, select Some.
6. When prompted for the table name; enter it.
7. When prompted for the index name; enter it.
8. When prompted for the table name again (in case you want to rebuild multiple indexes in multiple tables); enter "!" to indicate that we have finished enterng table and index names.
9. When prompted whether the list you entered is correct; enter "y".
10. When prompted whether you have enough disk space for sorting ; enter "y" if you know that you do have enough space. (See Solution 13568, "How to estimate disk space needed for sorting by idxbuild" for details.)
11. Once index rebuild is finished without errors, the index will be active.
Alternatively, you can use the command: proutil <db> -C idxfix (See solution P16016 - Can idxfix be used to activate an inactive index? for details.)