The system table LOCK_WAITS describes the lock requests.
LOCK_WAITS
TABLENAME |
CHAR(32) |
Name of the table |
TABLEID |
CHAR(8) BYTE |
ID of the table |
H_TERMID |
CHAR(18) |
ID of user terminal that holds the lock |
H_PROCESS |
FIXED(10) |
ID of user process that holds the lock |
H_APPLPROCESS |
FIXED(10) |
ID of process on the client hardware that holds the lock |
H_APPLNODE |
CHAR(64) |
ID of client hardware on which the application process runs that holds the lock |
H_ROWIDHEX |
CHAR(64) BYTE |
Start of the key of the locked row in hexadecimal notation |
H_ROWID |
CHAR(128) |
Start of the key of the locked row |
H_LOCKMODE |
CHAR(14) |
Type of lock (NULL value | SHARE | EXCLUSIVE) |
H_DATE |
DATE(10) |
Creation date of the lock |
H_TIME |
TIME(8) |
Creation time of the lock |
H_LOCKTIMEOUT |
CHAR(10) |
Always receives NULL value |
R_TERMID |
CHAR(18) |
ID of user terminal that requests the lock |
R_PROCESS |
FIXED(10) |
ID of user process that requests the lock |
R_APPLPROCESS |
FIXED(10) |
ID of process on the client hardware that requests the lock |
R_APPLNODE |
CHAR(64) |
ID of client hardware on which the application process runs that requests the lock |
R_ROWIDHEX |
CHAR(64) BYTE |
Start of key of requested row in hexadecimal format |
R_ROWID |
CHAR(128) |
Start of key of requested row |
R_REQMODE |
CHAR(14) |
Type of lock request (NULL value | SHARE | EXCLUSIVE) |
R_DATE |
DATE(10) |
Creation date of lock request |
R_TIME |
TIME(8) |
Creation time of lock request |
R_REQTIMEOUT |
CHAR(10) |
Time remaining until REQUEST_TIMEOUT has expired |
See also:
Concepts of the Database System, Locking for Database Objects