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

Lock Display Utility Commands

Lock Display presents a command-line environment that allows the entry of the following Lock Display commands. The commands are discussed in detail in the sections that follow.

 

Command

Description

BLOCKERS

Identifies the blocked transactions as well as their blocker transactions.

DB

Identifies the databases that have a database-level lock request.

HELP

Provides general help for the Lock Display utility.

QUIT

Exits lokdisp.

ROWKEY

Identifies a rowhash-level lock request. Rowhash lock information is provided also.

ROWRANGE

Identifies a rowrange-level lock request. Rowrange lock information is provided also.

TABLE

Identifies a table-level lock request.

TRAN

Identifies currently running transactions with locks being applied.

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.

Note: lokdisp 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. To view output examples, see “DB” on page 673 and “TABLE” on page 683.