15.10 - Restarting A Job - Parallel Transporter

Teradata Parallel Transporter User Guide

prodname
Parallel Transporter
vrm_release
15.10
category
User Guide
featnum
B035-2445-035K

Teradata PT provides fault tolerance by allowing a stopped job to restart from an internal checkpoint rather than requiring that the job be rerun from the beginning.

For information on using tbuild to setup job-specific checkpoint and restart options “Setting tbuild Options” on page 139.

Consider the following Teradata PT job stop/restart scenarios:

  • If the Teradata Database restarts, the job waits until the database is back online and then automatically resumes the job from the last known checkpoint.
  • If the job was held up by a Teradata Database lock and the lock is resolved, the job automatically resumes the from the last known checkpoint.
  • If you pause a job using the twbcmd JOB PAUSE option, you can restart it from the same point it was paused using the twbcmd JOB RESUME option. The JOB PAUSE command automatically takes a checkpoint.
  • If you terminate a job using the twbcmd JOB TERMINATE option, it takes a checkpoint and is restartable from that point.
  • If a job fails due to a fatal error, you can manually restart the job from the last recorded checkpoint before the error occurred, resubmitting the job.