Job Options - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2436
lifecycle
previous
Product Category
Teradata Tools and Utilities

Job Options

Checkpointing and Restarting

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 Teradata Parallel Transporter User Guide.

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.