A paused Teradata MultiLoad job is one that was halted, before completing, during the acquisition phase of the Teradata MultiLoad operation. The paused condition can be intentional, or the result of a system failure or error condition.
Pause a Teradata MultiLoad job intentionally by using a PAUSE ACQUISITION command between the BEGIN MLOAD command and the END MLOAD command in the Teradata MultiLoad job script.
Unintentional conditions that can pause a Teradata MultiLoad job include:
- A Teradata MultiLoad job script error
- An unrecoverable I/O error
- A down AMP recovery
- A database restart
- A database system reconfiguration
- A job abort or client system failure
The following topics describe the various pause conditions, the factors affecting Teradata MultiLoad restart operations, and, where appropriate, the procedure for restarting the Teradata MultiLoad job.
There is a data signature included in checkpoint information. That data signature is validated during a restart and may result in new errors at the beginning of a restart.