Progress
Database Administration
Guide and Reference


PROMON Transactions Control Option

Displays information about distributed transactions in a database. Figure 19–12 shows an example of this option’s output.

Transaction Control: 
Usr  Name   Trans   Login   Time   R-comm?   Limbo?   Crd?   Coord  Crd-task 
  2  paul   757  07/25/01   10:15    yes      yes      no    sports1   760 
      .    .     .      .           .   .         .         .     .      . 
      .    .     .      .           .   .         .         .     .      . 
      .    .     .      .           .   .         .         .     .      . 
RETURN - repeat, U - continue uninterrupted, Q - quit 

Figure 19–12: Sample Output For PROMON Transaction Control Option

NOTE: If you run PROMON against a database where no limbo transaction has occurred, Progress does not display any field information on the Transaction Control screen.

DISPLAY FIELDS
Usr

The number of the user running the distributed transaction.

Name

The name of the user running the distributed transaction.

Trans

The transaction number on the machine where you are running PROMON.

Login

The date the user running the distributed transaction began the Progress session.

Time

The time the user running the distributed transaction began the Progress session.

R-comm?

The state of the transaction. If this field is yes, the transaction is in a ready-to-commit state. This means that the first phase of two-phase commit is complete.

Limbo?

Whether a transaction is a limbo transaction. If one or more limbo transactions occur, the Limbo field displays a yes for each transaction listed. A yes in this field means that you must resolve transactions.

Crd?

Whether the database you are running PROMON against is the coordinator.

Coord

The name of the coordinator database.

Crd-task

The transaction number of the coordinator database.


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