If the load utility does not start because of a user error such as a nonexistent data file or invalid column names, the operation terminates and leaves the target table in a normal state. In such a case, the table is already in normal state and no further action is needed.

When the load operation begins, the target table is placed in the “Load in Progress” state. In the event of a failure, the table state changes to “Load Pending.” To remove the table from this state, you can issue a LOAD TERMINATE to roll back the operation, issue a LOAD REPLACE to reload the entire table, or issue a LOAD RESTART.

The REPLACE option deletes all existing data from the table and inserts the source data. The TERMINATE option rolls back the failed LOAD operation to its original state even if consistency points were passed. The RESTART option can be used when the SAVECOUNT parameter is specified. The SAVECOUNT parameter provides consistency points to prevent total loss of table data that has been inserted into the table. This option is useful for large load operations since the LOAD time may take hours. If this option is used and the LOAD operation fails, the RESTART option may be used to continue the LOAD at the last consistency point it reached.

Once you have fixed the situation that caused the load operation to fail, reissue the load command. Ensure that you specify exactly the same parameters as in the original command, so that the load utility can find the necessary temporary files.