Viewing Transaction Status

How To

The transaction status page displays operating system statistics from the SYSINFO table. Transaction status items and their corresponding SYSINFO.INFO values are summarized in Table.

 

Transaction Status Items

Description

Number of started transactions

The cumulative number of transactions started during the current runtime. (NUM_STARTED_TRANX)

Number of committed transactions

The cumulative number of committed transactions during the current runtime. (NUM_COMMITED_TRANX)

Number of aborted transactions

The cumulative number of transactions aborted in the current runtime. (NUM_ABORTED_TRANX)

Number of specified checkpoints

The cumulative number of checkpoints made during the current runtime. (NUM_CHECKPOINTS)

Number of transactions waiting group commit

The cumulative number of transactions waiting for a group commit action during the current runtime. (NUM_COMMIT_WAITER)

Table: Transaction Status items


Related topic:

Monitoring Database Status
Transaction Information