Output Description

address

is the shared-memory address of the transaction structure.

flags

The flag codes for position 1:

A

User thread attached to the transaction

S

TP/XA suspended transaction

C

TP/XA waiting for rollback

The flag codes for position 3:

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 codes for position 5:

G

Global transaction

C

Distributed query coordinator

S

Distributed query subordinate

B

Both distributed query coordinator and subordinate

Extended Parallel Server

R

Transaction with remote object references

End of Extended Parallel Server

userthread

is the user that owns the transaction (rstcb address).

locks

is the number of locks that the transaction holds.

log begin

is the log in which begin work was logged.

isolation

is the isolation level.

retries

is the attempts to start a recovery thread for the distributed query.

coordinator

is the transaction coordinator when this transaction is a subordinate.

The last line of the onstat -x output displays the maximum number of concurrent transactions since you initialized the database server. For example, the last line of onstat -u output is as follows:

13 active, 128 total, 18 maximum concurrent

The last part of the line, 18 maximum concurrent, indicates that the maximum number of transactions that were running concurrently since you initialized the database server is 18.

Using onstat -x With onstat-G and onmode -Z

The output of onstat -x is used to determine the address parameter for a distributed transaction. You can use this parameter along with the output from onstat -G to determine the global transaction ID (XTM-Id). This ID is useful in managing distributed transactions. For more information see Kill a Distributed Transaction.