15.00 - LIST LOCKS - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

LIST LOCKS

Purpose  

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

Syntax  

 

Syntax element...

Specifies...

LOCKS

to displays locks held by online transaction recovery.

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  

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  Row hash    "SampleDB"."pseudo table"
Exclusive  Table       "SampleDB"."SampleTable"