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]](figure/zu170030.gif)
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).