16.20 - Restarting A Job - Parallel Transporter

Teradata® Parallel Transporter User Guide

Parallel Transporter
Release Number
August 2020
English (United States)
Last Update

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.

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.