LOCK_WAITS
The system table DOMAIN.LOCK_WAITS
describes the lock requests.
|
CHAR(32) |
Name of the table |
|
CHAR(8) BYTE |
Identification of the table |
|
CHAR(18) |
Identification of user terminal that holds the lock |
|
FIXED(10) |
Identification of user process that holds the lock |
|
FIXED(10) |
Identification of process on the client hardware that holds the lock |
|
CHAR(64) |
Identification of client hardware on which the application process runs that holds the lock |
|
CHAR(64) BYTE |
Start (prefix) of the key of the locked row in hexadecimal notation |
|
CHAR(128) |
Start (prefix) of the key of the locked row |
|
CHAR(14) |
Type of lock (NULL value | SHARE | EXCLUSIVE) |
|
DATE |
Start date of database session that holds the lock |
|
TIME |
Start time of database session that holds the lock |
|
CHAR(10) |
Always receives NULL value |
|
CHAR(18) |
Identification of user terminal that requests the lock |
|
FIXED(10) |
Identification of user process that requests the lock |
|
FIXED(10) |
Identification of process on the client hardware that requests the lock |
|
CHAR(64) |
Identification of client hardware on which the application process runs that requests the lock |
|
CHAR(64) BYTE |
Start (prefix) of the key of the requested row in hexadecimal notation |
|
CHAR(128) |
Start (prefix) of the key of the requested row |
|
CHAR(14) |
Type of lock request (NULL value | SHARE | EXCLUSIVE) |
|
DATE |
Start date of database session that requests the lock |
|
TIME |
Start time of database session that requests the lock |
|
CHAR(10) |
Time remaining until request timeout has expired |