Kbase P101777: How to add an index or indices with the most uptime prior to 10.1A?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/16/2009 |
|
Status: Verified
GOAL:
How to add an index or indices with the most uptime prior to 10.1A?
GOAL:
How to build an index online prior to version 10.1A (but not activate online)?
FACT(s) (Environment):
Progress 8.2x
Progress 8.3x
Progress 9.x
OpenEdge 10.0x
FIX:
Add an index inactive (defined within the data definition file) and use the idxfix option of proutil to build the keys of the index online but in the background.
proutil <dbname> -C idxfix
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.
Choose option 1.
You will be shown the following prompt menu:
Select one of the following:
All - Check all the indexes
Some - Check only some of the indexes
Quit - Quit, do not check
If you choose the Some option then you may choose 1 table and 1 index at a time but may specify more than one in total for the session.
After you are done adding tables and indices put an exclamation mark as response to the prompt.
Performing the idxfix will generate a read on every record of every table you define for the idxfix. This may negatively effect performance for your database while it is running but the database will still be online so others may also work with the database.
After the idxfix is performed you will need to shutdown the database and re-run the same idxfix with the same options on the same tables and indices to activate all the indices which were just built.
If the idxfix is performed soon after it completes building the indices, so long as no massive number of changes were performed to the tables which idxfix completed building keys for, then the offline idxfix should be relatively quick to build any keys which were created or modified after the idxfix was run online. The idxfix will then activate the indices.
You should backup the database at this point and restart your database.