TRANSACTIONHISTORY
This system table SYSINFO.TRANSACTIONHISTORY contains information about active and ended transactions of a database.
|
TRANS ACTION ID |
FIXED(15) |
ID of the transaction |
|
TASK ID |
FIXED(10) |
ID of the database task |
|
WRITETRANSACTIONID |
FIXED(15) |
ID of a write transaction |
|
STARTDATE |
TIMESTAMP |
Start time of the transaction |
|
END DATE |
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.
Concepts of the Database System, Transactions