Restarting A Job - Parallel Transporter

Teradata® Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2022-02-04
dita:mapPath
kyx1608578396289.ditamap
dita:ditavalPath
tvt1507315030722.ditaval
dita:id
B035-2445
lifecycle
previous
Product Category
Teradata Tools and Utilities

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 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 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.