8.13 Database status in the event of an error and recovery method

If an error occurs during execution of pdrorg, check Tables 8-38 and 8-39 to determine the progress of the processing and take appropriate action. In the case of reorganization (-k rorg) that involves consecutive execution of unload and reload operations, if an error occurs during a reload operation, the data for the corresponding table is placed in reload-not-completed data status, in which case only the reload operation (-k reld) can be re-executed. You cannot use pdload on such a table that is in reload-not-completed data status to execute data loading in the addition mode, nor can you use pdrbal to execute rebalancing. If reloading is not possible because the unload data file has been deleted, you can release the reload-not-completed data status by executing the PURGE TABLE statement or pdload in the creation mode.

Table 8-38 Message output during execution of pdrorg and action to be taken (1/2)

Option value during execution of pdrorgMessage output during execution of pdrorg
712 and 732
uld
714 and 734
uld
721712 and 732
rld
714 and 734
rld
725715716
-k rorg -j omitted8.13.18.13.18.13.28.13.28.13.2[Figure]8.13.28.13.2
-k rorg -j specified
-k unld -j omitted[Figure][Figure][Figure][Figure][Figure]
-k unld -j specified
-k reld -j omitted[Figure][Figure]8.13.28.13.28.13.28.13.28.13.2
-k reld -j specified
-k ixmk[Figure][Figure][Figure]8.13.38.13.3
-k ixrc8.13.3
-k ixor8.13.48.13.48.13.4
Legend:
[Figure]: Not applicable
712 and 732 uld: Data unloading started
712 and 732 rld: Data reloading started
714 and 734 uld: Data unloading completed
714 and 734 rld: Data reloading completed
715: Index creation started
716: Index creation completed
721: Data deleted
725: Index information searched
Note
Messages are abbreviated. For example, 712 means KFPL00712-I and 732 means KFPL00732-I.

Table 8-39 Message output during execution of pdrorg and action to be taken (2/2)

Option value during execution of pdrorgMessage output during execution of pdrorg
712 and 732
uld
714 and 734
uld
721712 and 732
rld
714 and 734
rld
-k rorg -j omitted8.13.58.13.58.13.68.13.68.13.6
-k rorg -j specified[Figure][Figure][Figure][Figure][Figure]
-k unld -j omitted8.13.58.13.5
-k unld -j specified[Figure][Figure]
-k reld -j omitted8.13.58.13.58.13.68.13.68.13.6
-k reld -j specified[Figure][Figure][Figure][Figure][Figure]
-k ixmk
-k ixrc
-k ixor
Legend:
[Figure]: Not applicable
712 and 732 uld: Unloading of LOB data started
712 and 732 rld: Reloading of LOB data started
714 and 734 uld: Unloading of LOB data completed
714 and 734 rld: Reloading of LOB data completed
721: LOB data deleted
Note
Messages are abbreviated. For example, 712 means KFPL00712-I and 732 means KFPL00732-I.
Organization of this section
8.13.1 Error when unloading
8.13.2 Error when reloading
8.13.3 Error when creating an index in batch mode or re-creating an index
8.13.4 Error when reorganizing an index
8.13.5 Error when unloading LOB data
8.13.6 Error when reloading LOB data