# show transactions

    show transactions

Shows the XID for all client transactions that were created using the XA or MS DTC interfaces. Each row presents information about one transaction. The XID is the concatenation of the Format ID, GTrid Len, Bqual Len, and Data fields for a transaction. For example, if show transactions returns the row:

    State  Format ID  GTrid Len  Bqual Len  Data
      E      0          6          2        branchid

then the XID is `0 6 2 branchid`.

Note that the spaces are required.

show transactions (description of output fields)
Heading | Description
--- | ---
State | Transaction state: `A` active `E` ended `R` rollback only `P` prepared `S` suspended Suspended transactions can be rolled back, but cannot be rolled forward (committed).
Format ID | The XA transaction format identifier. `0 = OSI CCR` naming is used `>0 = some` other format is used -1 = NULL
GTrid Len | The number of bytes that constitute the global transaction ID.
Bqual Len | The number of bytes that constitute the branch qualifier.
Data | The global transaction identifier (gtrid) and the branch qualifier (bqual).

Copyright © Cloud Software Group, Inc. All rights reserved.