Deactivate indexes can be reactivated when the database is offline by performing either an IDXBUILD or IDXFIX. In order to do so, either utility has to be run with the database offline. While IDXBUILD is only an offline utility, IDXFIX can also be run online, however it will then only build but not activate indexes.
IDXBUILD Method:Always ensure a valid backup prior to running IDXBUILD. If the index operation fails for any reason, the database will remain inaccessible until the build flag is cleared by a successful run.
$ proutil dbname -C idxbuild [+ performant parameters available for OE version in use]
Once started, a menu selection will be presented offering a choice of which indexes to build:
- In earlier versions, the option “Some” can be used to then instruct the specific table + index name combinations to build. Enter an "!" exclamation mark to indicate the end of the table/index combinations to build.
- Since OpenEdge 10.1C, more Options are available to select specific indexes to be built. "Some" can still be used but other Options could be considered for the scope of the current index build operation:
All (a/A) - Choose all the indexes
Some (s/S) - Choose only some of the indexes
By Area (r/R) - Choose indexes in selected areas
By Schema (c/C) - Choose indexes by schema owners
By Table (t/T) - Choose indexes in selected tables
By Activation (v/V) - Choose active or inactive indexes
Follow subsequent menu driven prompts as the index build operation requires.
On successful completion the following message will confirm the index has been activated:
Index # ( Owner.Tablename, Indexname ): activated (8830)
Index rebuild complete. 0 error(s) encountered. (1644)
IDXFIX Method:
$ proutil dbname -C idxfix
Once started, a menu selection will be presented:
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.
Select
Option 1. Scan records for missing index entries, which will then scan the associated database records selected in the next menus for missing index keys.
The next menu offers a choice of which indexes to fix:
- In earlier versions, the option “Some” can be used to then instruct the specific table + index name combinations to fix. Enter an "!" exclamation mark to indicate the end of the table/index combinations to build.
- Since OpenEdge 10.1C, more Options are available to select specific indexes to be fixed. "Some" can still be used but other options could be considered for the scope of the current index fix operation:
All (a/A) - Choose all the indexes
Some (s/S) - Choose only some of the indexes
By Area (r/R) - Choose indexes in selected areas
By Schema (c/C) - Choose indexes by schema owners
By Table (t/T) - Choose indexes in selected tables
By Activation (v/V) - Choose active or inactive indexes
When prompted to “Fix indexes on Scan” answer: Y
Follow subsequent menu driven prompts as the index fix operation requires.
On successful completion the following message will confirm the index has been activated:
Index # ( Owner.Tablename, Indexname ): activated (8830)
# of indexes, # of blocks, # keys checked.
Index fix completed.
