TRANSACTIONHISTORY 
This system table SYSINFO.TRANSACTIONHISTORY contains information about active and ended transactions of a database.
Structure
TRANSACTIONID |
FIXED(15) |
ID of the transaction |
TASKID |
FIXED(10) |
ID of the database task |
WRITETRANSACTIONID |
FIXED(15) |
ID of a write transaction |
STARTDATE |
TIMESTAMP |
Start time of the transaction |
ENDDATE |
TIMESTAMP |
End time of the transaction |
STATE |
CHAR(10) |
Status of the transaction (ACTIVE | COMMITTED | ROLLBACKED) |
COMMENT |
CHAR(2048) |
Comment on the transaction |
The maximum number of possible entries is determined via the parameter TransactionHistorySize.
More Information
Concepts of the Database System, Transactions