16.10 - Checkpointing and Restarting - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
16.10
Published
July 2017
Content Type
Programming Reference
Publication ID
B035-2436-077K
Language
English (United States)

The Update operator takes a checkpoint at the beginning and the end of the acquisition phase. More granular checkpoints during the acquisition phase can be specified using the -z option of the tbuild command, which specifies checkpoint intervals in terms of seconds. For example:

   tbuild -f <file name> -z 120

In this example, the -f option specifies the name of the script that is input to tbuild, and the -z option indicates that a checkpoint is taken every 120 seconds.

For more information about checkpoints and restarts, see the Teradata Parallel Transporter User Guide (B035-2445).

The Update operator cannot be rolled back. Once changes are applied to target tables in the application phase, a job can only move forward.

Since a target table cannot be returned to its original state, it is advisable to archive tables prior to running Update operations against them.

To restart a job from the beginning (and bypass the restart log table) do the following:

  1. Drop the restart log table.
  2. Drop the error and work tables.
  3. Drop the checkpoint files.

To discontinue an Update operation and drop the target tables, do the following:

  1. Drop the restart log table.
  2. Drop the error and work tables.
  3. Drop the target tables.