The system table <DATABASE_SYSTEM_ADMINISTRATOR>.OMS_LOCKOBJ_INFO contains information about locks that are explicitly held or requested using the OmsLockObject.
PROCESS |
FIXED(10) |
ID of the task that holds or requests the lock |
SESSION |
FIXED(10) |
ID of the session that holds or requests the lock |
USERNAME |
CHAR(32) |
Name of the user that holds or requests the lock |
TERMID |
CHAR(18) |
ID of the terminal that the connected application uses |
APPLPROCESS |
FIXED(10) |
Operating system ID of the connected application |
APPLNODEID |
CHAR(64) |
Name of the computer of the remotely connected application |
LOCK_HANDLE |
CHAR(8) BYTE |
User-defined ID of the lock |
LOCK_MODE |
CHAR(14) |
Type of lock (NULL | SHARE | EXCLUSIVE) |
REQ_MODE |
CHAR(14) |
Type of lock in case of a collision with timeout wait situations (NULL | SHARE | EXCLUSIVE) |
REQ_TIMEOUT |
CHAR(10) |
Time remaining before timeout (s) |
Concepts of the Database System, Locks
Database Administration in CCMS, OMS Locks, OMS Monitor