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

Teradata® FastLoad Reference - 17.20

Product
FastLoad
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2022-10-11
dita:mapPath
dlf1641281592734.ditamap
dita:ditavalPath
vax1619194969834.ditaval

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.