Kbase P107164: Is idxbuild run with no integrity?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/08/2009 |
|
Status: Verified
GOAL:
Is idxbuild run with no integrity?
GOAL:
Why does ai have to be disabled to run idxbuild?
GOAL:
Why no message 512 on "proutil <db> -C idxbuild -i"
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
FIX:
Idxbuild is always run with no integrity. The first step of idxbuild is to truncate the Before Image (BI) afterwhich, no further BI-notes are written during the index build process.
Should the idxbuild fail, then you cannot access the database anymore. the following message is returned:
Index reconstruction utility was aborted. Rerun it to completion. (651)
Which is why it is always a good idea to have a backup of the database before running idxbuild.
As idxbuild does not log any recovery notes during its operation, after imaging must also be turned off.
Following message will occur on "proutil <db> -C idxbuild" in the case of AI still enabled:
You cannot perform this operation with after-imaging or 2phase enabled (1525)
Since the structure of the database changes during idxbuild, you need a new backup to reflect those changes (which means a new base for roll forward operations).
Adding the startup parameter "-i" is of no effect on idxbuild; the following message is not displayed:
** This session is being run with the no-integrity (-i) option. (512)