Commit and parent nodes

For distributed transactions coordinated by Adaptive Server, the “commit node” column lists the name of the server that executes the topmost branch of the distributed transaction. This transaction determines the commit or rollback status for all branches of the transaction. See “Hierarchical transaction coordination” for more information.

The “parent node” column lists the name of the server that initiated the transaction. In the sp_transactions output above, the “commit node” and “parent node” columns list the same server, caserv1. This indicates that the distributed transaction originated on caserv1, and caserv1 propagated a branch of the transaction to the current server.