16.10 - LIST LOCKS - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

Purpose

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

Syntax



LOCKS
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: Displaying a list of locks held by trasaction 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"