15.00 - After a Teradata Database Failure - FastLoad

Teradata FastLoad Reference

prodname
FastLoad
vrm_release
15.00
category
Programming Reference
featnum
B035-2411-034K

After a Teradata Database Failure

Restarting a Teradata FastLoad job that was paused because of a Teradata Database failure depends on the operational configuration of the Teradata Database when it returns to service:

  • If the configuration of the restarted Teradata Database is exactly the same as it was when Teradata FastLoad was invoked, then Teradata FastLoad restarts the job automatically. In this case, if the Teradata FastLoad job was paused in the end loading phase, the Teradata Database resumes processing at the same place it was stopped.
  • If the Teradata FastLoad job was paused in the loading phase, the Teradata Database resumes processing:

  • at the last checkpoint if the BEGIN LOADING command specified the checkpoint option.
  • at the beginning if the BEGIN LOADING command did not specify the checkpoint option.
  • Note: If the Teradata FastLoad job uses an INMOD routine, the routine must be able to handle restarts and checkpoints when restarted in the loading phase.

  • If the configuration of the restarted Teradata Database is different from the way it was when Teradata FastLoad is invoked, then Teradata FastLoad does not restart the job. In this case, to restart and continue with the paused Teradata FastLoad job, must reestablish the original configuration of the Teradata Database. If this is not possible, then the Teradata FastLoad job must:
  • a Delete the Teradata FastLoad table and error tables.

    b Resubmit the Teradata FastLoad job, from the beginning, as a new job.