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