Checkpoints - MultiLoad

Teradata® MultiLoad Reference

Product
MultiLoad
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2022-02-04
dita:mapPath
fel1608578437279.ditamap
dita:ditavalPath
kju1619195148891.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.