Object documentationTRANSACTIONHISTORY Locate this document in the navigation structure

 

This system table SYSINFO.TRANSACTIONHISTORY contains information about active and ended transactions of a database.

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 TransactionHistorySize.

More Information

Concepts of the Database System, Transactions