Using SAP ASE Coordination Services

The work of a local SAP ASE transaction is sometimes distributed to remote servers that modify remote data.

This can happen when a local transaction executes a remote procedure call (RPC) to update data in another SAP ASE table, or when a local transaction modifies data in a remote table using Component Integration Services (CIS).

• Overview of Transaction Coordination Services
  SAP ASE provides services to propagate transactions to remote servers and coordinate the work of all servers, ensuring that all work is either committed or rolled back as a logical unit.
• Requirements and Behavior
  SAP ASE transaction coordination services can ensure that the work of remote servers is logically committed or rolled back.
• Ensuring Sufficient Resources for Updates
  By default, the transaction coordination service is always enabled.
• Using Transaction Coordination Services on Remote Servers
  When SAP ASE propagates transactions to other SAP ASEs, it can ensure the integrity of the distributed transaction as a whole.
• Monitoring Coordinated Transactions and Participants
  SAP ASE tracks information about the status of work done in subordinate servers using data in the sybsystemdbdbo.syscoordinations system table.