Lock table status (_Lock)

The _Lock VST Displays the status of the lock table, including the user number, the user name, lock type, RECID number, flags, and chain.

Note: Use caution querying the _Lock table; frequent access can consume large quantities of system resources and negatively impact performance.
Field name Data type Description
_Lock-Chain INTEGER Chain number
_Lock-DomainId INT64 Domain Id for the user that owns the lock
_Lock-Flags CHARACTER Flags for the lock—the flags specify a share lock (S), exclusive lock (X), a lock upgraded from share to exclusive(U), a lock in limbo (L), a queued lock(Q), a lock kept across transaction end boundary (K), a lock is part of a JTAtransaction (J), a lock is in create mode for JTA (C), or a lockwait timeout has expired on this queued lock (E)
_Lock-Name CHARACTER User name
_Lock-PartitionId INTEGER Partition ID of the locked entry
_Lock-RecId INT64 RECID of the record and lock table entry
_Lock-Table INTEGER Table number
_Lock-TenantId INTEGER Tenant ID for the user that owns the lock
_Lock-Trans-Flags CHARACTER Transaction flags; see Lock Table
_Lock-Trans-State CHARACTER Transaction state; see PROMON Record Locking Table option
_Lock-TransId INTEGER Transaction id of the lock
_Lock-Tty CHARACTER Device from which the user has connected to the database; see also _Connect._Connect-Device
_Lock-Type CHARACTER Type of lock (for example, REC, RGET)
_Lock-Usr INTEGER User number of the user who owns the lock entry