Ensuring Sufficient Resources for Updates

By default, the transaction coordination service is always enabled.

The system administrator can enable or disable these services using the enable xact coordination configuration parameter. See System Administration Guide: Volume 1 > Setting Configuration Parameters for a complete description of this parameter.

The system administrator must also ensure that SAP ASE has the required resources to coordinate all of the RPCs and CIS updates that may be requested by transactions. Each time a transaction issues an RPC or CIS update, the transaction coordinator must obtain a free DTX participant. A DTX participant or “distributed transaction participant” is an internal memory structure that SAP ASE uses to coordinate a transaction that has been propagated to a subordinate SAP ASE. In the figure above, ASE1 requires three free DTX participants, and ASE2 requires two free DTX participants. (In each case, a single DTX participant is used to coordinate the local work of the transaction that is propagated.

DTX participant resources remain in use by the coordinating SAP ASE until the associated remote transaction has committed. This generally occurs some period of time after the initiating transaction has committed, since the initiating transaction commits as soon as all subordinate transactions have successfully prepared their work.

If no DTX participants are available, RPC requests and CIS update requests cannot proceed and the transaction is aborted.