Dropped Tables - Parallel Transporter

Teradata® Parallel Transporter Reference

Product
Parallel Transporter
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2023-11-29
dita:mapPath
abr1608578396711.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
ogv1478610452101
Product Category
Teradata Tools and Utilities

Some tables are created by the database during the execution of a job, and others must be user-created before the job begins. The log table and error table are automatically created by Teradata PT when you run the job script. The error table is dropped during the Cleanup phase if no errors were detected during the job, unless the DropErrorTable attribute is set to No. The log table is dropped after the job completes successfully.

If a job terminates abnormally, then the log and error tables are not dropped. If you want to restart the job from scratch, manually drop these tables by running a BTEQ script.

Care must be taken dropping the target tables manually using a BTEQ script. If something goes wrong with a Stream operator job, and you drop the target table manually and then try to rerun the job, original data can be lost.