The system table SYSINFO.TRANSACTIONS describes the status of all current transactions.
TASKID |
FIXED(10) |
ID of the task |
TRANSACTIONID |
FIXED(15) |
ID of the transaction |
STARTDATE |
TIMESTAMP |
Start time of the transaction |
WRITETRANSACTIONID |
FIXED(15) |
ID of a write transaction |
SQLLOCKREQUESTTIMEOUT |
FIXED(10) |
Timeout for SQL lock requests for database objects (s). This value may be different than the database parameter. |
OMSLOCKREQUESTTIMEOUT |
FIXED(10) |
Timeout for lock requests for OMS objects (s). This value may be different than the database parameter. |
LASTWRITE |
FIXED(10) |
Duration of a transaction that has made changes in the database (s) |
SQLLOCKMODE |
CHAR(14) |
Type of lock for SQL database objects (NULL value | SHARE | EXCLUSIVE) |
OMSLOCKMODE |
CHAR(14) |
Type of lock for OMS objects (NULL value | SHARE | EXCLUSIVE) |
REQUESTMODE |
CHAR(14) |
Type of lock in case of a collision with timeout wait situations (NULL value | SHARE | EXCLUSIVE) |
HISTORYROOT |
FIXED(10) |
First page in the chain of history pages |
HISTORYLAST |
FIXED(10) |
Last page in the chain of history pages |
HISTORYPAGECOUNT |
FIXED(10) |
Number of used history pages |
LASTHISTORYSEQUENCE |
FIXED(10) |
Last number assigned for a history entry |
CONSISTENTVIEWID |
FIXED(15) |
ID of the currently valid consistent view |
TASKTYPE |
CHAR(32) |
Task type |
Concepts of the Database System, Transactions, Locks