Kbase 37650: How to activate an inactive index.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/2/2001 |
|
Solution ID: P7650
GOAL:
How to activate an inactive index.
FIX:
The only way to activate an inactive index is to perform an index rebuild on the index itself. To do this:
1) Shut down the database.
2) Make sure you have a valid backup (in case the index rebuild utility should fail for any reason).
3) From the command prompt, run:
proutil <dbname> -C idxbuild
4) A menu will appear, select Some.
5) You will be prompted for the table name; enter it.
6) You will be prompted for the index name; enter it.
7) You will be prompted for the table name again (in case you want to rebuild multiple indexes at the same time); enter "!".
8) You will be asked whether the list you entered is correct; enter "y".
9) You will be asked whether you have enough disk space for sorting. Please see Progress Solution 13568 for how to answer this question.
Once index rebuild is finished without errors, the index will be active.