Summary information |
|
|---|---|
Default value |
0 (off) |
Valid values |
0 (off), 1(on) |
Status |
Static |
Display level |
10 |
Required role |
System administrator |
Configuration group |
DTM Administration |
strict dtm enforcement determines whether or not Adaptive Server transaction coordination services strictly enforce the ACID properties of distributed transactions.
In environments where Adaptive Server should propagate and coordinate transactions only to other Adaptive Servers 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, Adaptive Server 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 Adaptive Server and non-Sybase database stores configured using CIS. Under these circumstances, set strict dtm enforcement off to allow Adaptive Server to propagate transactions to legacy Adaptive Servers 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.
