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.
Heading | Description |
---|---|
State | Transaction state:
Suspended transactions can be rolled back, but cannot be rolled forward (committed). |
Format ID | The XA transaction format identifier.
-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). |