8.14.3 Error when creating an index in batch mode or re-creating an index

The table below shows the status of the database and recovery method in the event of an error during index re-creation or batch index creation.

Table 8-50 Status of database and recovery method in the event of error during re-creation or batch creation of an index

-l optionStatus/Recovery methodMessage output immediately before error occurred
None725715716
a or pStatusStatus before executionStatus before executionIndex not createdIndex creation completed
RecoveryRe-execute re-creationRe-execute re-creationExecute batch creation#Unnecessary
nStatusTableStatus before executionStatus before executionStatus before executionStatus before execution
IndexStatus before executionStatus before executionNot guaranteedCreation completed
RecoveryTableUnnecessaryUnnecessaryUnnecessaryUnnecessary
IndexRe-execute re-creationRe-execute re-creationRe-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 the index to be recovered is a plug-in index, the utility can be executed only if the batch plug-in index creation partial recovery facility is provided. Otherwise, the index re-creation process is re-executed.