Rollback/Rollforward Operations Exclusive and Read Utility 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

Rollback and rollforward operations place these utility (HUT) locks:

  • Exclusive locks on the tables to be recovered.
  • A read utility lock on the journal table that is input to the recovery operation.

A journal table with a read utility lock can still log change images. The read utility lock on the journal table does prevent concurrent Teradata ARC statements, such as DELETE JOURNAL.