Open transactions
None
| Name | Data Type | Description |
|---|---|---|
| INSTANCEID | long | Instance ID; 0 = non-CE |
| XACTKEY | string(32) | Transaction key |
| TYPE | string(12) | Transaction type (Local, External, Dtx_State, Remote) |
| COORDINATOR | string(12) | Coordination method (None, Syb2PC, ASTC, XA, DTC) |
| STARTTIME | time | Start time of transaction |
| ELAPSEDTIME | long | Elapsed time, in seconds |
| STATE | string(20) | Current state of the transaction:
|
| CONNECTION | string(12) | Connection state (Attached, Detached) |
| DBID | long | Starting database ID |
| DBNAME | string(32) | Starting database name |
| TEMPDBNAME | string(32) | Name of the tempdb assigned to the process |
| SPID | long | Session process ID; 0 = Detached process |
| LOID | long | Lock owner ID |
| FAILOVER | string(28) | Transaction failover state (Resident Tx, Failed-over Tx, Tx by Failover-Conn) |
| SRVNAME | string(32) | Remote server name, if applicable |
| NAMELEN | long | Length of transaction name |
| XACTNAME | string(256) | Transaction name, or XA transaction ID (XID) |
| GTRID_XA | string(512) | Binary version of the global transaction ID portion of XID |
| BQUAL_XA | string(512) | Binary version of the branch qualifier portion of XID |
| KPID | long | Kernel process ID |
| LOGIN | string(32) | Login name of process |
| APPLICATION | string(32) | Application name of process |
| CLIENTHOST | string(32) | Client host name of process |
| CLIENTIP | string(68) | Client host IP address of process |
| CLIENTOSPID | string(32) | Client OS PID of process |
| Attributes: | None |
|---|---|
| Minimum database version: | 12.5.0.3 |