onstat -G

Use the -G option to display information about global transactions generated through TP/XA. For more information on TP/XA, see the IBM Informix TP/XA Programmer's Manual.

Example Output

Figure 101 shows an example of onstat -G output:

Figure 101. onstat -G Output

Global Transaction Identifiers
address  flags  isol   timeout fID     gtl  bql  data
c736618  --R-G  DIRTY   45   4478019 16   48   438709F23076254C80F33A62BAF4CF763
C1BCFFAD7AE0243AA5CE243FA5381C903AA9F52A1546044992C5A7BC03582E77999EFBA725D3D40B
DAF37404D9DAFF8
**br**   -----  DIRTY   45   4478019 16   48   438709F23076254C80F33A62BAF4CF763
C1BCFFAD7AE0243AA5CE243FA5381C903AA9F52A1546044992C5A7BC03582E77999EFBA725D3D40B
DAF37404D9DAFF8
 1 active, 128 total

Output Description

The flag codes for position 1 (current transaction state):

A: User thread attached to the transaction
S: TP/XA suspended transaction
C: TP/XA waiting for rollback

The flag codes for position 2 (transaction mode):

T: Tightly-coupled mode (MTS)
L: Loosely-coupled mode (default mode)

The flag codes for position 3 (transaction stage):

B: Begin work
P: Distributed query prepared for commit
X: TP/XA prepared for commit
C: Committing or committed
R: Rolling back or rolled back
H: Heuristically rolling back or rolled back

The flag code for position 4:

X: XA DataSource global transaction

The flag codes for position 5 (type of transaction):

G: Global transaction
C: Distributed query coordinator
S: Distributed query subordinate
B: Both distributed query coordinator and subordinate