The “gtrid” column displays the global transaction ID for distributed transactions coordinated by Adaptive Server. Transaction branches that are part of the same distributed transaction share the same gtrid. You can use a specific gtrid with the sp_transactions gtrid keyword to determine the state of other transaction branches running on the current server. This is useful for System Administrators who must determine whether a particular branch of a distributed transaction should be heuristically committed or rolled back. See “Determining the commit status for Adaptive Server transactions” for an example that uses sp_transactions with the gtrid keyword.
For
transactions coordinated by an X/Open XA-compliant transaction manager,
MSDTC, or SYB2PC, the gtrid column shows the
full transaction name supplied by the external coordinator.
