Setting CHECKPOINT to 0 - TARA/ABU

Teradata Archive/Recovery Utility Reference

Product
TARA/ABU
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-01
dita:mapPath
utr1488824663491.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2412
lifecycle
previous
Product Category
Teradata Tools and Utilities

If CHECKPOINT is set to 0:

  • Teradata ARC does not save positioning into the restart log. This means there is no restart/reconnect support. Some RESTORE/COPY operations also die with an error because no positioning information is saved.
  • CATALOG is not supported and automatically disabled. Restart processing terminates with a fatal error.

For some tape drives, tape positioning information is not available or is very expensive. Setting CHECKPOINT to 0 allows more efficient processing in these cases.

Setting CHECKPOINT to 0 is not the same as setting CHECKPOINT to a very large number. If CHECKPOINT is set to a very large number, Teradata ARC still saves some checkpoint information in the restart log, such as the beginning of database/table, and restart/reconnect is supported at database/table boundaries.
Some applications that use Teradata ARC do not support positioning activity. To prevent positioning activity, set CHECKPOINT to 0.