Failed or incomplete loads

Restarting an interrupted load operation
If a failure or interruption occurs during a load operation, you can use the load utility to terminate the operation, reload the table, or restart the load operation.
Restarting or terminating an ALLOW READ ACCESS load operation
An interrupted or canceled load operation that specifies the ALLOW READ ACCESS parameter can also be restarted or terminated using the ALLOW READ ACCESS parameter. Using the ALLOW READ ACCESS parameter allows other applications to query the table data while the terminate or restart operation is in progress. As with a load operation in ALLOW READ ACCESS mode, the table is locked exclusively before the data being committed.
Recovering data with the load copy location file
The DB2LOADREC registry variable is used to identify the file with the load copy location information. This file is used during rollforward recovery to locate the load copy.
Load dump file
Specifying the dumpfile file type modifier tells the load utility the name and the location of the exception file to which rejected rows are written.
Load temporary files
The Db2® database system creates temporary binary files during load processing. These files are used for load crash recovery, load terminate operations, warning and error messages, and runtime control data.
Load utility log records
The utility manager produces log records associated with a number of Db2 utilities, including the load utility.

Parent topic: Load utility