Transactions view
Figure 3–23 shows the Transactions view. All the data associated with transactions currently being processed within the database appears in this single view. The information for this view comes from the _Trans VST table. The view presents a snapshot of the 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–23: 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.
The Active state is read to determine the data for the Duration and Start Time.- State — The state of the transaction (Allocated, Active, or Committing). Allocated means the transactions have been "announced" to the database, but not yet started.
- 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 displays if two-phase commit is in use.
- Coord Tx — The number of the transaction on the coordinator database. Coord Tx displays if two-phase commit is in use.
Copyright © 2006 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |