Checkpoints - MultiLoad

Teradata MultiLoad Reference

Product
MultiLoad
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-07-11
dita:mapPath
cgb1488824663145.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval
dita:id
B035-2409
lifecycle
previous
Product Category
Teradata Tools and Utilities

To support Teradata MultiLoad restart operations, the INMOD routine must support checkpoint operations, as described in Teradata MultiLoad/INMOD Routine Interface.

If an INMOD routine that does not support the checkpoint function is used, a job may encounter problems when Teradata MultiLoad takes a checkpoint.

By default, Teradata MultiLoad takes a checkpoint every 15 minutes. To bypass the Teradata MultiLoad checkpoint function specify a CHECKPOINT rate of zero in the BEGIN MLOAD command; that way, the job completes without taking a checkpoint.

When the CHECKPOINT rate is greater than 60, the specified number refers to the number of records, not the number of minutes. Though this would nullify the Teradata MultiLoad restart/reload capability, it would allow use of an INMOD routine that does not support the checkpoint function.