Object documentationOMS_LOCKOBJ_INFO Locate this document in the navigation structure

 

The system table <DATABASE_SYSTEM_ADMINISTRATOR>.OMS_LOCKOBJ_INFO contains information about locks that are explicitly held or requested using the OmsLockObject.

Structure

OMS_LOCKOBJ_INFO

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)

More Information

Concepts of the Database System, Locks

Database Administration in CCMS, OMS Locks, OMS Monitor