Kbase P10257: What is a Mock Index build and how does it affect the database?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Verified
GOAL:
What is a mock index rebuild?
FACT(s) (Environment):
All Supported Operating Systems
FIX:
A mock index build differs drastically from performing a customary index build against a database. The only purpose of the mock index build is to eliminate the "db is damaged, dump its data and reload" message. A mock index build performs no other function. The index build utility is used to compress index blocks, activate deactivated indexes, and repair corrupted index entries within the database.
The "db is damaged, dumps its data and reload" message is written to the screen on database startup and to the database log file after the database has been forced into. A dump and reload is always the **recommended** step after the database was forced into. In extreme cases a company may have to wait to perform the dump in load, in the interim time a mock index build can be used to remove the "db is damage" flag. The mock index build only removes the message from appearing at database startup and does not perform any fix operations against the database.
To perform a mock mock index build perform the following:
1 - proutil dbname -C idxbuild.
2 - From the Index Rebuild Utility.
Index Rebuild Utility
=====================
Select one of the following:
All - Rebuild all the indexes
Some - Rebuild only some of the indexes
Quit - Quit, do not rebuild
Enter your selection:
When prompted to "Enter your selection" Type "some" at the prompt and hit return.
4- At that point the idxbuild utility will prompt you to:
Enter the name of table containing the index.
Enter ! to indicate input is complete. (9176)
Table name:
5 - For the table name enter in an exclamation point (!).
6 - When prompted "Is this correct?" enter y to answer yes .
7- The idxbuild utility will then prompt:.
Do you have enough disk space for index sorting (y
).
8- enter y.
9- A message indicating that an Index build completed with zero errors will be displayed.
Although the Mock index build is not updating or repair the index entries the mock index build does in fact read through all the index blocks within the database thus taking some time.