The Microsoft DRDA Service does not support the option to disable XA transactions on connections between the DRDA Service and servers that are running Microsoft SQL Server. An option to configure this feature was not implemented.
To improve performance for workloads that do not require full end-to-end protected distributed transactions, the Microsoft DRDA Service configuration and runtime libraries are updated in this update to support the option to disable XA transactions on connections between DRDA Service and SQL Server computers.
To disable XA, specify the following in the sqlApplicationManager portion of the "hostIntegration.drdaAs.drdaService" section of the MsDrdaService.exe.config file:
- disableXaTransaction = "true"
The fix that resolves this problem is included in the following cumulative updates for Host Integration Server:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Learn about the terminology Microsoft uses to describe software updates.
Third-party information disclaimer
The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products.