If the load utility cannot start because of a user error, such as a nonexistent data file or invalid column names, it will terminate and leave the table space in a normal state.
If a failure occurs while loading data, you can restart the load operation from the last consistency point (using the RESTART option), or reload the entire table (using the REPLACE option). Specify the same parameters as in the previous invocation, so that the utility can find the necessary temporary files.