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 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 reorganization | Re-execute reorganization | 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 reorganization | Re-execute reorganization | Re-execute batch creation after recovering database# | Unnecessary |
#: If you recovered the index storage RDAREA by re-initializing the RDAREA instead of using its backup copy, re-execute the index re-creation.