> #### Transactions view

> Figure 3–24 shows the Transactions view. All the data associated with transactions currently being processed within the database display in this single view. The information for this view comes from the _Trans VST table. This view presents a snapshot of this data at the date and time specified at the top of the page. To avoid viewing stale data on this page, select the Refresh icon periodically.

> Figure 3–24: Transactions page

> The display includes the following columns:

> - 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 (either 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. Displayed for active transactions.
> - Start Time — When the transaction started. Displayed for active transactions.
> - Coord DB — The name of the coordinator database. Displays if two-phase commit is in use.
> - Coord Tx — The number of the transaction on the coordinator database. Displays if two-phase commit is in use.

Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095