17.10 - LIST LOCKS - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

The LIST LOCKS command displays all locks currently held by transaction recovery.

Syntax

LIST LOCKS ;

Usage Notes

The report displays the mode of the lock held (write or exclusive), the object type locked (database, table, row range, or row hash) and the name of the object. The report is sorted alphabetically by object name.

For row range and row hash locks, the row information does not display. Only the table within which the row resides is displayed.

If rcvmanager is unable to determine the database name associated with an object, rcvmanager displays the database ID in decimal and hex. The same is true if the table name cannot be determined.

LIST LOCKS displays only those locks currently held by transaction recovery. You cannot display locks held by online catchup or offline catchup.

Example: Displaying a list of locks held by transaction recovery

Only a single report is generated by the LIST LOCKS command. An example of this report is shown below:

LOCKS HELD BY ONLINE TRANSACTION RECOVERY at
02:29:16 04/06/16

Lock        Lock      Object
Mode       Object      Name
----       ------      ----
Write      Database    "AssetsDB"
Write      Row hash    "Clients"."TurnOver"
Write      Row hash    "EmployeeInfo"."NewHires"
Exclusive  Table       "SampleDB"."SampleTable"