LOCKS
This
system table contains information on locks that have been set.LOCKS
|
SESSION |
FIXED(10) |
Database session identification |
|
TRANSCOUNT |
FIXED(10) |
Transaction identification in the database session |
|
PROCESS |
FIXED(10) |
Process identification in the database session |
|
USERNAME |
CHAR(32) |
User name |
|
DATE |
DATE |
Creation date of the lock |
|
TIME |
TIME |
Creation time of the lock |
|
TERMID |
CHAR(18) |
User terminal identification |
|
LASTWRITE |
CHAR(10) |
Elapsed time since the last SQL statement for data manipulation |
|
LOCKMODE |
CHAR(14) |
Type of lock |
|
LOCKSTATE |
CHAR(10) |
Status of lock |
|
APPLPROCESS |
FIXED(10) |
Process identification on the client hardware |
|
APPLNODE |
CHAR(64) |
Client hardware identification |
|
OWNER |
CHAR(32) |
table owner |
|
TABLENAME |
CHAR(32) |
Name of the table |
|
TABLEID |
CHAR BYTE(8) |
Table identification |
|
ROWIDLENGTH |
FIXED(3) |
Length of the key of the locked row |
|
ROWIDHEX |
CHAR BYTE(64) |
Start of the key of the locked row in hexadecimal notation |
|
ROWID |
CHAR(128) |
Start of the key of the locked row |