Delete Journal Operations Write Lock - 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

DELETE JOURNAL places transaction locks, not utility (HUT) locks. When the operation finishes, Teradata Archive/Recovery Utility automatically releases all transaction locks.

DELETE JOURNAL places a write lock on the journal table to be deleted. DELETE JOURNAL deletes only the saved journal, therefore the active portion of the journal can still log change images during the delete operation. Other archive or recovery operations are not permitted.