Try OpenEdge Now
skip to main content
Database Administration
Reference : Virtual System Tables : Virtual system table summaries : Lock table status (_Lock)
 
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 name
_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-User
INTEGER
User number of the user who owns the lock entry