Checkpoints - Parallel Data Pump

Teradata® Parallel Data Pump Reference

Product
Parallel Data Pump
Release Number
16.20
Published
September 2019
Language
English (United States)
Last Update
2019-10-11
dita:mapPath
dmq1512702641516.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-3021
lifecycle
previous
Product Category
Teradata Tools and Utilities

Teradata TPump supports the use of checkpoints. Checkpoints are entries posted to a restart log table at regular intervals during the Teradata TPump data transfer operation. If processing stops while a Teradata TPump job is running, the job can be restarted at the most recent checkpoint.

For example, assume 1,000,000 records are being loaded into a table and have specified checkpoints every 50,000 records. Then Teradata TPump pauses and posts an entry to the restart log table whenever multiples of 50,000 records are successfully sent to Teradata Database.

If the job stops after record 60,000 has been loaded, the job can be restarted at the record immediately following the last checkpoint, record 50,001.

To enable the checkpoint function, specify a checkpoint value in the BEGIN LOAD command. For more information, see BEGIN LOAD.