Displays status information about the lock table. See Manage 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 1. 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 2 for a description of the possible states