Kbase P50898: DBRPR performed but no IDXBUILD and getting 3636 errors
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/4/2005 |
|
Status: Unverified
SYMPTOM(s):
Accessing database causes error 3636
System crashed due to power failure
** Those dates don't match, so you have the wrong copy of one of them. (888)
** The before-image file expected <date/time>. (887)
** The database was last used <date/time>. (886)
Error:
SYSTEM ERROR: bksteal: Attempt to read block <block-num> above high water mark <block-num2>. (3636)
DBRPR was used to correct bad blocks and bad fragments
Idxbuild was not performed
CAUSE:
An Index Build is necessary if DBRPR is used to make changes to the database.
DBRPR does not modify index notes, so although it will update the Record Manager information it will not post the changes to the Indices related to those records.
IDXBUILD is necessary to update those changes.
FIX:
Perform idxbuild all after using dbrpr to correct problems within a database.
In some cases if exact knowledge of what table(s) dbrpr corrected the idxbuild may be curtailed to just the indices for the table(s) that was/were repaired.