16.20 - Automatic Dropping of Error Tables - 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

Teradata PT applies the following rules to error tables:

  • Since Teradata PT automatically creates error tables each time a job runs, the error tables from the previous job run must be dropped before the next time the job runs.
  • Teradata PT automatically drops error tables for successful job runs, that is, job runs with an exit code of 0 or 4. This includes jobs that succeed on the first run, as well as those that succeed after being repaired and rerun.
  • Teradata PT does not automatically drop error tables for jobs that terminate with an exit code of 8 or 12 (to allow use of the error tables for debugging the job), or if the DropErrorTable is set to No.