Checkpoint Operation Transaction Locks - Teradata Tools and Utilities

Teradata® Archive/Recovery Utility Reference

Product
Teradata Tools and Utilities
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-06-05
dita:mapPath
fac1527114221922.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2412
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.