Lock Table

Database Administration

Reference : PROMON Utility : R&D Status Displays : Lock Table

Lock Table

Displays status information about the lock table. See Managing Performance for a description of the lock table and its functions. When you choose this menu option, PROMON gives you five choices:

Display all lock entries

Display locks for one user

Display locks for one ROWID

Change list sorting

Match a tenant or tenants

PROMON Lock Table Status display

The following figure shows a sample Lock Table Status display.

08/04/11 Status: Lock Table by user number
18:25:23
Usr:Ten Name Domain Trans id Type Table:Part ROWID Flags Trans State
6:2 tenant2 tenant2 0 REC 5:0 4290 S None

The display contains the following fields:

Usr:Ten — The user number and tenant ID of the user who owns the lock entry

Name — For client processes, the user name; for a lock from a JTA transaction, <JTA> is displayed

Domain — The domain name of the use

Trans id — The transaction id

Type — The lock type (for example, REC, RGET)

Table:Part — The table number and partition ID

ROWID — The ROWID of the record and lock table entry

Flags — The table below lists the possible flags

Table 88. Lock table flags
Flag	Description
S	Share lock
X	Exclusive lock
U	Lock was upgraded from a share lock to an exclusive lock
L	Limbo—lock is being held until the transaction commits
Q	Request is queued, and the user is waiting for a conflicting lock held by another user
P	Purged
H	Hold

Trans State — Indicates the state of the transaction; see Table 79 for a description of the possible states