strict dtm enforcement

strict dtm enforcement determines whether or not SAP ASE transaction coordination services strictly enforce the ACID properties (atomicity, consistency, integrity and durability ) of distributed transactions.

Summary Information

Default value

0 (off)

Valid values

0 (off), 1(on)



Display level


Required role

System administrator

Configuration group

DTM Administration

In environments where SAP ASE should propagate and coordinate transactions only to other SAP ASEs that support transaction coordination, set strict dtm enforcement on. If a transaction attempts to update data in a server that does not support transaction coordination services, SAP ASE aborts the transaction.

In heterogeneous environments, you may want to make use of servers that do not support transaction coordination. This includes earlier versions of SAP ASE and non-SAP database stores configured using CIS. Under these circumstances, set strict dtm enforcement off to allow SAP ASE to propagate transactions to legacy SAP ASEs and other data stores. This does not, however, ensure that the remote work of these servers is rolled back or committed with the original transaction.