Restart Paused FastLoad Job After Failure | Teradata FastLoad - 17.10 - After a Client System or Teradata FastLoad Failure - FastLoad

Teradata® FastLoad Reference

Product
FastLoad
Release Number
17.10
Published
June 2021
Last Update
2021-07-01
Content Type
Programming Reference
Publication ID
B035-2411-061K
Language
English (United States)

When a client system or a Teradata FastLoad failure occurs while a Teradata FastLoad job is running, Teradata FastLoad performs the following tasks:

  1. Pauses the job.
  2. Tries to log off all Teradata FastLoad sessions on the database.
    locking error_table_name for access
    select errorcode, errorfieldname
    from error_table_name;

To access the Teradata FastLoad target table, a Teradata FastLoad job consisting of a BEGIN LOADING and an END LOADING command must be submitted. This effectively restarts and ends the job.

After executing the END LOADING command, the Teradata FastLoad target table can be accessed, but the original job cannot be restarted.

The following subsections describe the various pause conditions, the factors affecting Teradata FastLoad restart operations, and the procedure for restarting a paused Teradata FastLoad job.