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 cancelled load operation that specifies
the ALLOW READ ACCESS option can also be restarted
or terminated using the ALLOW READ ACCESS option.
Using the ALLOW READ ACCESS option 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 prior to 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
DB2® 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.