Kbase P32202: How to run an online idxfix to check one indexed field?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/15/2005 |
|
Status: Verified
GOAL:
How to run an online idxfix to check one indexed field?
GOAL:
Is it possible to fix indexes online?
FIX:
As long as the index is not de-activated, then the online idxfix utility can be run to build all indexes defined, but will not activate disabled indexes.
Completing index activation will require an idxfix offline of the same index, which will then activate the deactivated index if no corruption is found. Idxbuild on the other hand, is an offline utility which, will activate all indexes because it re-builds them from scratch. The time that it will take to build the index entries is directly related to how complex the index is and how many records are involved. It may take a long time if there are a lot of records.
The performance of idxfix online is affected by other online users and specifically running transactions. The process of an online idxfix operation runs SHARE-LOCK. It constantly waits, grabs, and releases locks. If there are other transactions requiring the same locks, idxfix will have to compete against these and this could cause a performance hit. Progress advises to run this utility during times of low load.
The command line is:
proutil [ dbname ] -C idxfix
An "Index Fix Utility" menu will be presented, select:
OPTION 3 "Both 1 (Scan records for missing index entries.) and 2 (Scan indexes for invalid index entries.) above.
At the next prompt enter: some
Then enter: the Table name
and the index name at the following prompt
(Note, this may be repeated for every Table and index combination that is in need of checking and fixing. It is also possible to feed this information in through a text file for larger investigations.)
Then enter: !
to indicate that the range is complete
A confirmation message will display all the tables and indexes that have been selected for investigation. Enter: y
"Validate recids for index entries." Enter: y
(the following is the flag to fix corruption found or only to report it) -
" Fix indexes on Scan." Enter: y
"Provide a range of records to scan through."
Unless you can be sure of the range and Area, Enter: ALL
The idxfix operation will now start.
The idxfix operation will report it's findings