Using Host Utility 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
A Host Utility (HUT) lock, also referred to as a utility lock in this book, is the lock that Teradata ARC places when most Teradata ARC commands are executed. Exceptions are CHECKPOINT, DELETE DATABASE, and DELETE JOURNAL. When Teradata ARC places a HUT lock on a object, for example, with an ARCHIVE or RESTORE command, the following conditions apply:
  • HUT locks are associated with the currently logged-on user who entered the statement, not with a job or transaction.
  • HUT locks are placed only on the AMPs that are participating in a Teradata ARC operation.
  • A HUT lock that is placed for a user on an object at one level never conflicts with another level of lock on the same object for the same user.

The ShowLocks utility, described in Utilities (B035-1102), shows the HUT locks that are currently applied to a Teradata Database.