16.10 - Lock Display Utility Commands - 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

Lock Display presents a command-line environment that allows the entry of the following Lock Display commands.

Command Description
BLOCKERS Displays currently blocked transactions and the corresponding blocking transactions.
DB Displays granted and blocked databases-level locks.
HELP Provides general help for the Lock Display utility.
QUIT Exits Lock Display.
PARTITION Displays granted and blocked partition-aware locks. These types of locks by default can only lock a single row partition; however, for the DBC.AccessRights table, they can also lock a single rowhash or all rowhashes across a range of row partitions.
ROWKEY Displays granted and blocked row-level locks.
ROWRANGE Displays granted and blocked locks on contiguous ranges of rows (ranges of rowhash values).
TABLE Displays granted and blocked table-level locks.
TRAN Displays currently running transactions with lock requests that have been granted or blocked.

Commands are case-insensitive and may be abbreviated.

Lock Display interprets numeric input as hex (the default radix is hex). To enter decimal format numeric values, follow the number with a period character. For example, ten decimal must be entered as “10.”. An unmodified “10” is interpreted as hex value 0x10, equivalent to the decimal value sixteen.

Lock Display displays a series of question mark (?) characters if it does not find user, database, or table names in the cache or, in the case of DDL statements, in the Data Dictionary. For examples of this, see DB and TABLE.

The following sections describe the commands and show examples of the output when various types of locks are present.

Because the TRAN command shows all transactions for which locks are being applied or blocked, it is described first, and the ROWKEY, ROWRANGE, PARTITION, and BLOCKERS commands, which display subsets of the TRAN command output, are described after TRAN.