8.13.4 Error when reorganizing an index

Table 8-42 shows the status of the database and recovery method in the event of an error during index reorganization.

Table 8-42 Status of database and recovery method in the event of error during index reorganization

-l optionStatus/Recovery methodMessage output immediately before error occurred
None725715716
a or pStatusStatus before executionStatus before executionIndex not createdIndex creation completed
RecoveryRe-execute reorganizationRe-execute reorganizationExecute batch creation*Unnecessary
nStatusTableStatus before executionStatus before executionStatus before executionStatus before execution
IndexStatus before executionStatus before executionNot guaranteedCreation completed
RecoveryTableUnnecessaryUnnecessaryUnnecessaryUnnecessary
IndexRe-execute reorganizationRe-execute reorganizationRe-execute batch creation after recovering database*Unnecessary
Legend:
725: Index unloading started
715: Batch index creation started
716: Batch index creation completed
Note
Messages are abbreviated. For example, 725 means KFPL00725-I.

* If you recovered the index storage RDAREA by re-initializing the RDAREA instead of using its backup copy, re-execute the index re-creation.