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.