Checkpoint Operation Transaction Locks - 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

The CHECKPOINT statement places transaction locks rather than utility (HUT) locks. Transaction locks are automatically released when the checkpoint operation terminates. A checkpoint operation places:

  • A write lock on the journal table for which checkpoints are being set.
  • Read locks on the data tables that may contribute change images to the journal table for which checkpoints are being set.

The operation places these locks and then writes the checkpoint. After the operation writes the checkpoint, Teradata ARC releases the locks.

If a journal is marked for later archiving using CHECKPOINT with the SAVE option, the AMP places an access lock on the data tables instead of a read lock.