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.