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.