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.

However, the work of a local SAP ASE transaction is sometimes distributed to remote servers that do not support transaction coordination services. This may occur when a transaction uses RPCs to update data in earlier SAP ASE versions, or when CIS services are used to update data in non-SAP databases. Under these circumstances the coordinating SAP ASE cannot ensure that the work of remote servers is committed or rolled back with the original transaction.

• Set the strict dtm enforcement Parameter
  The system administrator can enforce or relax the requirement to have distributed transactions commit or roll back as a logical unit by setting the strict dtm enforcement configuration parameter.