7.7.1 Overview of error handling procedure

The procedure depends on the abnormal termination timing. Figure 7-6 shows the error handling procedure in the event of abnormal termination of a utility during data loading with the synchronization point specification.

Figure 7-6 Error handling procedure in the event of abnormal termination of a utility during data loading with the synchronization point specification

[Figure]

Explanation:
  • The total number of entries subject to data loading is three million with one million line numbers with synchronization points.
  • If the utility terminates abnormally in step 1, 3, or 5, reexecute data loading.
  • If the utility terminates abnormally in step 2 or 4, re-create the plug-in index using the database reorganization utility's batch index creation facility (-k ixmk), and then reexecute data loading.
  • If the utility terminates abnormally in step 6, re-create the plug-in index using the database reorganization utility's batch index creation facility (-k ixmk), and then create the B-tree index using the database reorganization utility's index re-creation facility (-k ixrc).
  • If the utility terminates abnormally in step 7 and an index information file has already been created (the KFPL00710-I message is output), create the B-tree index using the database reorganization utility's batch index creation facility (-k ixmk). If the index information file has not been created, create the B-tree index using the database reorganization utility's index re-creation facility (-k ixrc).