8.14.4 Error when reorganizing an index

The table below shows the status of the database and recovery method in the event of an error during index reorganization.

Table 8-51 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.