USE LOCK Keywords - 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

USE LOCK specifies the lock level Teradata ARC applies to data tables that contribute rows to the journal tables on which Teradata ARC is setting checkpoints.

With USE LOCK, request the specified lock level on the data tables for a journal in the object list. When Teradata ARC obtains the requested lock, it writes the checkpoint and then releases the lock. Teradata ARC then requests locks for data tables for the next journal table in the object list. Teradata ARC places journal tables in the object list in alphabetical order by database name.

If an ACCESS LOCK is specified, making updates to data tables while generating the checkpoint is supported. If a checkpoint is taken with an ACCESS LOCK, any transaction that has written images to the journal and has not been committed is logically considered to have started after the checkpoint was taken.

When specifying an ACCESS LOCK, also specify the WITH SAVE option.

READ LOCK is the default, resulting in Teradata ARC suspending all updates to the tables until it writes the checkpoint record. Use READ LOCK to identify the transactions included in the archive.