Transactions view

The Transactions view displays all the data associated with transactions currently being processed within the database.

From the Database details page, click Transactions in the Operational Views section. The Transactions view appears, and displays a graph indicating transaction activity over time and the DB transactions summary section. For more information about graphs, see GraphicalDisplays of Database Data.

The DB transactions summary section has the following fields and columns:

Allocated transactions — The number of transactions allocated.

Display allocated — Whether to display the allocated transactions (No or Yes).

Trans # — The transaction number.

User — The user who entered the transaction. This information reflects the information available in the User Activity view.

User # — The number of the user listed in the User column. This information reflects the information available in the User Activity view.

State — The state of the transaction (Allocated, Active, or Committing). Allocated means the transactions have been "announced" to the database, but not yet started.

The Active state is read to determine the data for the Duration and Start Time.

Duration — How much time has passed since the transaction started. Duration is displayed for active transactions.

Start Time — When the transaction started. Start Time is displayed for active transactions.

Coord DB — The name of the coordinator database. Coord DB appears if two-phase commit is in use.

Coord Tx — The number of the transaction on the coordinator database. Coord Tx appears if two-phase commit is in use.

The information for this view comes from the _Trans VST table.