Try OpenEdge Now
skip to main content
Database Administration
Reference : Virtual System Tables : Virtual system table summaries : Lock request (_LockReq)
 
Lock request (_LockReq)
The _LockReq VST displays information about lock requests, including user name and number, record locks and waits, schema locks and waits, and transaction locks and waits.
Field name
Data type
Description
_LockReq-ExclFind
INT64
Number of exclusive lock finds acquired by the user
_LockReq-Name
CHARACTER
User name
_LockReq-Num
INTEGER
User number
_LockReq-RecLock
INT64
Number of record locks acquired by the user
_LockReq-RecWait
INT64
Number of times the user had to wait for a record lock
_LockReq-SchLock
INT64
Number of schema locks acquired by the user
_LockReq-SchWait
INT64
Number of times the user had to wait for a schema lock
_LockReq-ShrFind
INT64
Number of share locks released due to not satisfying a query
_LockReq-TenantId
INTEGER
Tenant ID of the user
_LockReq-TrnLock
INT64
Number of times a deleted record is protected until transaction end
_LockReq-TrnWait
INT64
Number of times a user waited for a record marked for deletion by an active transaction