TRANSACTIONS 
Definition
The statistics system table TRANSACTIONS contains information about active transactions of a database instance.
Structure
TRANSACTIONS
SESSION |
FIXED(10) |
ID of the database session |
TRANSCOUNT |
CHAR(20) |
ID of the transaction |
SUB_TRANS |
FIXED(10) |
Number of the current subtransaction |
WRITE_TRANS |
CHAR(6) BYTE |
ID of the current write transaction, if this has made a change |
PROCESS |
FIXED(10) |
ID of the user process |
USERNAME |
CHAR(32) |
User name |
CONNECTDATE |
DATE |
Date of start of session |
CONNECTTIME |
TIME |
Time of start of session |
TERMID |
CHAR(18) |
ID of the terminal |
REQTIMEOUT |
CHAR(10) |
Seconds remaining until time specified in special database parameter REQUEST_TIMEOUT |
LASTWRITE |
CHAR(10) |
Elapsed time since last write request in timeout intervals |
LOCKMODE |
CHAR(14) |
Type of lock (NULL value | SHARE | EXCLUSIVE) |
LOCKSTATE |
CHAR(10) |
Status of lock |
REQMODE |
CHAR(14) |
Type of lock request (NULL value | SHARE | EXCLUSIVE) |
REQSTATE |
CHAR(10) |
Status of lock request |
CONSISTENTVIEW |
CHAR(6) BYTE |
For future use |
APPLPROCESS |
FIXED(10) |
ID of the application process |
APPLNODEID |
CHAR(64) |
ID of the client computer of the application process |
The system table TRANSACTIONS exists only to enable compatibility with older database versions. Instead of the statistics system table TRANSACTIONS, use the system table TRANSACTIONS.