16.20 - Restarting a Job "Catch Up" - Parallel Transporter

Teradata® Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-27
dita:mapPath
uah1527114222342.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval

Here are the steps for switching the load protocol to perform “catch up”:

  1. Terminate the current job with the TERMINATE command. This forces the job to take a checkpoint before it terminates.
  2. Switch the load protocol by either changing the operator in the job variables file or by using another job variables file that has the new operator. The latter method is highly recommended because it prevents users from modifying existing job variables files.
  3. Resubmit the same job with the same command options.
    Do not cleanup the Teradata PT checkpoint files left from the previous run.

    The steps above can be easily automated because performing "catch up" is very similar to restarting a job. In most of the "catch up" cases, you do not need to modify the original scripts. This is all due to the advantages of having a single script language, external job variables to isolate changes to one place, and a common protocol for checkpoint restart across operators.