TRANSACTIONHISTORY 
Definition
This system table TRANSACTIONS contains information about active and ended transactions of a database instance.
Structure
TRANSACTIONHISTORY
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 TRANS_HISTORY_SIZE.
See also:
Concepts of the Database System, Transactions