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.