18.18.1 Overview of actions

The actions to be taken depend on the timing of the abnormal termination. Figure 18-5 shows the actions to be taken when a utility terminates abnormally during execution of a reorganization with synchronization points set.

Figure 18-5 Actions to be taken when a utility terminates abnormally during execution of a reorganization with synchronization points set

[Figure]

Note: Steps 6 and 7 may be performed in either order.

1 When the -g option is specified for execution of the database reorganization utility, KFPL00732-I is output.

2 When the -g option is specified for execution of the database reorganization utility, KFPL00733-I is output.

Explanation
  • The total number of data cases is 3 million; the number of synchronization points is 1 million.
  • If the utility terminates abnormally at point 1, re-execute table reorganization.
  • If the utility terminates abnormally at a point between 2 and 5, unloading has been completed. Therefore, use the database reorganization utility (-k reld) to execute reloading.
  • If the utility terminates abnormally at point 6, reloading of table data has been completed. Therefore, create only the plug-in index and the B-tree index. Using the created index information file as the input information, use the database reorganization utility to create the plug-in index and B-tree index in the batch mode (-k ixmk).
  • If the utility terminates abnormally at point 7, create only the B-tree index. Using the created index information file as the input information, use the database reorganization utility to create the B-tree index in the batch mode (-k ixmk).