Table 8-40 shows the database status and recovery method in the event of an error during a reload operation. The recovery method depends on the options specified for execution of the database reorganization utility. If an error occurs during reload operation, check the specified options and the message output immediately before the error occurred, as shown in Table 8-40, and then recover the error.
Table 8-40 Database status and recovery method in the event of an error during reload operation
Option | Status/Recovery method | Message output immediately before error occurred | ||||||
---|---|---|---|---|---|---|---|---|
-l | -i | None | 721 | 712 and 732 | 714 and 734 | 715 | 716 | |
a | s | Status | Status before exe | Null*2 | Null*2, *4 | Table crtn cmpled | ![]() | ![]() |
Recovery | Re-exe | Re-exe reload*1 | Re-exe reload*1 | ![]() | ||||
c | Status | Status before exe | Null*2 | Null*2, *4 | Table crtn cmpled | Index not created | Index crtn cmpled | |
Recovery | Re-exe | Re-exe reload*1 | Re-exe reload*1 | ![]() | Create index | Unnecessary | ||
p | s | Status | Status before exe | Null*2 | Null*2, *4 | Table crtn cmpled | ![]() | ![]() |
Recovery | Re-exe | Re-exe reload*1 | Re-exe reload*1 | ![]() | ||||
c | Status | Status before exe | Null*2 | Null*2, *4 | Table crtn cmpled | Index not created | Index crtn cmpled | |
Recovery | Re-exe | Re-exe reload*1 | Re-exe reload*1 | Create index | Create index | ![]() | ||
n | s | Status | Not guaranteed | Null*2 | Not guaranteed | Table crtn cmpled | ![]() | ![]() |
Recovery | Re-exe after recover database | Re-exe reload after recover database | Re-exe reload after recover database | ![]() | ||||
c | Status | Not guaranteed | Null*2 | Not guaranteed | Table crtn cmpled | Index not created | Index crtn cmpled | |
Recovery | Re-exe after recover database | Re-exe reload after recover database | Re-exe reload after recover database | Re-exe reload after recover database*3 | Re-exe reload after recover database*3 | ![]() |