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.
The value of the TargetTable attribute is truncated to the maximum number of characters for object names that the database supports, minus 3 characters before the suffix "_RL" is appended to the target table name. This means that if the value of the TargetTable attribute is a fully qualified table name and that fully qualified name exceeds the maximum supported length of a database object, the generated name 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.