Table 8-41 shows the status of the database and recovery method in the event of an error during re-creation or batch creation of an index.
Table 8-41 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.