When a table is row-partitioned into multiple back-end servers, unload data file consolidation (-g specification for the database reorganization utility) is recommended. If the unload data files are not consolidated, the actions to be taken when the utility terminates abnormally become complicated.
This section explains the actions to be taken when a utility terminates abnormally during reorganization or reloading with synchronization points set before the unload data files have been consolidated.
If the unload data files have not been consolidated, it is necessary to check whether or not reorganization processing was completed at each server. Figure 18-6 shows the system configuration used for the explanation.
Figure 18-6 Case where the table is row-partitioned into multiple back-end servers
As explained above, the database reorganization utility must be re-executed individually for each server taking into consideration the timing of abnormal termination.
Reorganization with synchronization points set was executed without consolidating the unload data files. The system configuration is as shown in Figure 18-6. It is assumed that reorganization in BES1 terminated abnormally during unloading and reorganization in BES2 terminated abnormally during reloading.
The control information file of the database reorganization utility and the command specification when the utility terminated abnormally are shown below:
Control information file (/pdrorg/rorg01) specification
option job=j01,200 |
pdrorg command specification
pdrorg -k rorg -t TABLE1 /pdrorg/rorg01 |
Reorganization must be re-executed for the tables in BES1; reloading must be executed for the tables in BES2. Therefore, the database reorganization utility must be executed individually for BES1 and BES2.
The control information file of the database reorganization utility and the command specification for re-executing the utility are shown below.
Control information file (/pdrorg/rorg01) specification
option job=j01,200 |
Control information file (/pdrorg/rorg02) specification
option job=j01,200 |
pdrorg command specification
pdrorg -k rorg -t TABLE1 /pdrorg/rorg01 |