Two-phase commit (2PC) transactions
None
| Name | Data Type | Description |
|---|---|---|
| COMMID | long | ID of two-phase commit |
| SUID | long | Server user ID, for XA transactions; -1 = Non-XA transaction |
| SUSERNAME | string(32) | Server user name, for XA transactions |
| START | time | Start time of transaction |
| LASTCHANGE | time | Last time the row was updated |
| TOTNUM | long | Total number of servers initially involved in the transaction |
| OUTNUM | long | Number of servers that have not yet completed |
| HEUR | string(8) | Was heuristically completed (yes, no) |
| STATUS | string(12) | Status of two-phase commit transaction (abort, begin, commit, prepare) |
| XID | string(284) | XA transaction ID (XID) |
| APPLNAME | string(32) | Application name |
| XACTNAME | string(32) | Transaction name |
| PASSWD | string(32) | Blank |
| BQUAL | string(512) | Binary version of the branch qualifier portion of XID |
| GTRID | string(512) | Binary version of the global transaction ID portion of XID |
| Attributes: | None |
|---|---|
| Minimum database version: | 15.0 |