Kbase P16490: How to reactivate a deactivated index when the database is offline?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/11/2009 |
|
Status: Verified
GOAL:
How to reactivate a deactivated index when the database is offline?
GOAL:
How can I reactivate one index for a specific table when the database is offline?
GOAL:
How to build and index only for on index within a table when the database is offline?
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
FIX:
Deactivated indexes can be reactivated when the database is offline by performing either an idxbuild or idxfix against the database or specific table and index name. Both utilities need to be ran with the database offline. Although idxfix can also be ran as an online utility, it cannot reactivate indexes when the db is online.
Idxbuild Method:
----------------
Command: proutil dbname -C idxbuild
1. Will prompt you for All, Some or Quit
If you select "Some" you will be prompted for table and index names you want
to rebuild. When you have completed entering the table and index names you
wish to rebuild, you will need to enter an "!" exclamation point to indicate
end of listing.
2. You will then be prompted to confirm what you have entered. Type y.
3. You will be asked if you have enough space for sorting. Answer.
4. Messages will be displayed indicating that the the index has been rebuilt
as well as sorting information. Upon completion you will receive the
following information:
Index # ( Owner.Tablename, Indexname ): activated (8830)
Index rebuild complete. 0 error(s) encountered. (1644)
Idxfix Method:
----------------
Command: proutil dbname -C idxfix
1. Upon entering the command, the following menu will be displayed:
Index Fix Utility
1. Scan records for missing index entries.
2. Scan indexes for invalid index entries.
3. Both 1 and 2 above.
4. Cross-reference check of multiple indexes for a table.
5. Build indexes from existing indexes.
6. Delete one record and it's index entries.
7. Quit.
Enter selection:
Select option 1.
2. Will prompt you for All, Some or Quit
If you select "Some" you will be prompted for table and index names you
want to rebuild. When you have completed entering the table and index names you wish to rebuild, you will need to enter an "!" exclamation point to
indicate end of listing.
3. You will then be prompted to confirm what you have entered. Type y.
4. Then you will be prompted if you would like to fix indexes on scan. Type y.
5. You will then be prompted for a range of records to scan through (All or
recid). Type all.
6. You will then be prompted to confirm what you have entered. Type y
7. The utility will scan the database records for missing keys. And will report the following:
Index # ( Owner.Tablename, Indexname ): activated (8830)
# of indexes, # of blocks, # keys checked.
Index fix completed.
For additional information on which utility is better for your specific situation reference, What is the best utility to use to reactivate an index?