If an error occurs during execution of pdrorg, check Tables 8-37 and 8-38 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-37 Message output during execution of pdrorg and action to be taken (1/2)

Option value during execution of pdrorg	Message output during execution of pdrorg
	712 and 732 uld	714 and 734 uld	721	712 and 732 rld	714 and 734 rld	725	715	716
-k rorg -j omitted	8.13.1	8.13.1	8.13.2	8.13.2	8.13.2		8.13.2	8.13.2
-k rorg -j specified
-k unld -j omitted
-k unld -j specified
-k reld -j omitted			8.13.2	8.13.2	8.13.2		8.13.2	8.13.2
-k reld -j specified
-k ixmk							8.13.3	8.13.3
-k ixrc						8.13.3
-k ixor						8.13.4	8.13.4	8.13.4

Legend:

: 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-38 Message output during execution of pdrorg and action to be taken (2/2)

Option value during execution of pdrorg	Message output during execution of pdrorg
	712 and 732 uld	714 and 734 uld	721	712 and 732 rld	714 and 734 rld
-k rorg -j omitted	8.13.5	8.13.5	8.13.6	8.13.6	8.13.6
-k rorg -j specified
-k unld -j omitted	8.13.5	8.13.5
-k unld -j specified
-k reld -j omitted	8.13.5	8.13.5	8.13.6	8.13.6	8.13.6
-k reld -j specified
-k ixmk
-k ixrc
-k ixor

Legend:

: 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