The system table DOMAIN.LOCK_WAITS describes the lock requests.
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 (prefix) of the key of the locked row in hexadecimal notation |
H_ROWID |
CHAR(128) |
Start (prefix) of the key of the locked row |
H_LOCKMODE |
CHAR(14) |
Type of lock (NULL value | SHARE | EXCLUSIVE) |
H_DATE |
DATE |
Start date of database session that holds the lock |
H_TIME |
TIME |
Start time of database session that holds 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 (prefix) of the key of the requested row in hexadecimal notation |
R_ROWID |
CHAR(128) |
Start (prefix) of the key of the requested row |
R_REQMODE |
CHAR(14) |
Type of lock request (NULL value | SHARE | EXCLUSIVE) |
R_DATE |
DATE |
Start date of database session that requests the lock |
R_TIME |
TIME |
Start time of database session that requests the lock |
R_REQTIMEOUT |
CHAR(10) |
Time remaining until request timeout has expired |
Concepts of the Database System, Locks