Displays information about distributed two-phase commit transactions in a database.

Sample output for PROMON 2PC Transaction Control option

The following 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
Note: If you run PROMON against a database where no limbo transaction has occurred, PROMON does not display any field information on the Transaction Control screen.
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 session.
Time
The time the user running the distributed transaction began the 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?
If 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?
If 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.