17.10 - Lock Display Utility Commands - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Utilities

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Publication ID
English (United States)

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

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.