Kbase P47520: Why is my index rebuild taking longer than it normally does?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/4/2005 |
|
Status: Unverified
SYMPTOM(s):
Why is my index rebuild taking longer than it normally does?
Can't find selected index list file .xb; assuming ALL. (2786)
CAUSE:
Index Build was terminated before completion.
FIX:
If an index build is intentionally killed or terminates abnormally for some reason it should leave a file behind <database name>.xb.
In some cases the .xb file may not exist see solution P68731 How to perform an idxbuild on original tables / indexes when an idxbuild operation fails."
A bug existed in version 9 but was fixed in 9.1D09 which left out of date .xb files from prior failed index rebuilds on the system. If the date on the .xb file is not the same as the date when the idxbuild was last performed the file may not be correct.
When the proutil -C idxbuild session sees this file it will add an additional prompt when performing the next idxbuild.
If you aren't aware of this prompt and are using an input file with predefined keystrokes to control the idxbuild your responses to the questions will not be in sync with the questions asked.
This will likely cause your idxbuild to skip sorting which will then cause it to take longer to perform the index build since all sorting will be done in memory and will take approximately 5 times longer on average.
The extra question that will be asked is:
PROGRESS Version 9.1D as of Fri Oct 10 05:14:41 EDT 2003
Index reconstruction resumes. (2747)
Previous index rebuild was interrupted. This is a new try.
(2748)
Can't find selected index list file .xb; assuming ALL. (2786)
Is this correct? (y
)
If you answer yes it will immediately proceed to the following question:
Do you have enough disk space for index sorting? (y
)
If you answer no it will proceed to the following question:
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:
It would be best when running your idxbuild script to conditionally test for <database name>.xb and if that file exists then use an alternate input file which appropriately responds to the questions that the idxbuild will prompt for.