The SQL/MP driver supports one-phase commit. It can participate in a distributed transaction if it is the only one-phase commit data source being updated in the Transaction.

Both the transaction environment properties convertAllToDistributed and useCommitConfirmTable must be set to true.

If Using Attunity Connect as a Stand-alone Transaction Coordinator is necessary, in the Configuration Properties, set convertAllToDistributed to TRUE.

If you want to use SQLMP as one-phase commit data source participating in a Two-phase Commit distributed transaction, in the Configuration Properties, set useCommitConfirmTable to TRUE.

Other than the above conditions, do not set either of the above-mentioned parameters to TRUE.