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 option | Status/Recovery method | Message output immediately before error occurred | ||||
---|---|---|---|---|---|---|
None | 725 | 715 | 716 | |||
a or p | Status | Status before execution | Status before execution | Index not created | Index creation completed | |
Recovery | Re-execute re-creation | Re-execute re-creation | Execute batch creation# | Unnecessary | ||
n | Status | Table | Status before execution | Status before execution | Status before execution | Status before execution |
Index | Status before execution | Status before execution | Not guaranteed | Creation completed | ||
Recovery | Table | Unnecessary | Unnecessary | Unnecessary | Unnecessary | |
Index | Re-execute re-creation | Re-execute re-creation | Re-execute batch creation after recovering database# | Unnecessary |
#: 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.