Usage Notes - Parallel Transporter

Teradata Parallel Transporter Reference

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

LogTable

A restart log table, which contains restart information written during job runs, is required for any execution of the Stream operator. Specify a restart log table in scripts with the LogTable attribute.

Restarts can occur following any unexpected error on a database. For example, if a table runs out of available space during a load operation, the job terminates, the table is paused, and a checkpoint is recorded in the restart log. Pausing the job in this way allows you to manually increase the available space, if needed, then restart the job because the load operation can restart a job from the last checkpoint in the restart log.

If you do not specify a name for LogTable, the Stream operator automatically creates a name of the log table as follow:

ttname_RL

where ttname is the name of the corresponding target table.

Note: The value of the TargetTable attribute is truncated to 27 characters before the suffix "_RL" is appended. This means that if the value of the TargetTable attribute is a fully qualified table name and the fully qualified name exceeds the maximum supported length of a database object (30 characters), the generated names for the log table may not be what you intend. In such a case, Teradata recommends that you provide the names of the log table and not rely on the Stream operator to generate the names for log table automatically.