Restarting a Checkpoint Operation - 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

When CHECKPOINT writes rows to a journal, the transient journal also keeps a record of these rows. Consequently, if the Teradata Database fails, the results of the checkpoint operation are rolled back by the transient journal.

  • If Teradata ARC statement specified checkpoints on multiple journal tables, Teradata ARC rolls back only the checkpoint being taken at the time of the hardware failure.
  • If CHECKPOINT terminates abnormally, all locks Teradata ARC placed are removed.

When Teradata ARC restarts, the CHECKPOINT statement completes.