The system table DOMAIN.LOCKS describes the current lock entries and entries for lock requests.
SESSION |
FIXED(10) |
ID of the database session |
TRANSCOUNT |
CHAR(20) |
ID of the transaction in the database session |
PROCESS |
FIXED(10) |
ID of the process in the database instance |
USERNAME |
CHAR(32) |
Name of the user |
DATE |
DATE |
Start date of database session that holds the lock |
TIME |
TIME |
Start time of database session that holds the lock |
TERMID |
CHAR(18) |
ID of the user |
LASTWRITE |
CHAR(10) |
Elapsed time since the last SQL statement for data manipulation |
LOCKMODE |
CHAR(14) |
Type of lock (NULL value | SHARE | EXCLUSIVE) |
LOCKSTATE |
CHAR(10) |
Status of lock |
APPLPROCESS |
FIXED(10) |
ID of the process on the client hardware |
APPLNODE |
CHAR(64) |
ID of the client hardware |
SCHEMANAME |
CHAR(32) |
Name of the table schema |
OWNER |
CHAR(32) |
Name of the owner of the table |
TABLENAME |
CHAR(32) |
Name of the table |
TABLEID |
CHAR(8) BYTE |
ID of the table |
ROWIDLENGTH |
FIXED(4) |
Length of the key of the locked row |
ROWIDHEX |
CHAR(64) BYTE |
Start (prefix) of the key of the locked row in hexadecimal notation |
ROWID |
CHAR(128) |
Start (prefix) of the key of the locked row |