Identify the Transaction Coordinator

The coordinator column of systransactions indicates the method or protocol used to manage a transaction.

In the previous output, the local transaction $user_transaction does not have an external coordinator. The remote transaction taking place on caserv2 has the coordinator value “ASTC”. This indicates that the transaction is coordinated using native SAP ASE coordination services.

See sp_transactions in the Reference Manual for a complete list and description of possible coordinator values.