DSXchange

The mentioned ODBC/SQL performance issue can be fixed by adding the following environment variable

CC_ODBC_SET_COMMIT_MODE

and set the value to 1.

IBM confirmed that there apprears to be an issue whereby the auto commit property in the connector stage is not being honoured properly.

Adding the mentioned variable fixed the performance issue for us.

Thanks for the tip!

cdp wrote:Just a heads-up on anyone with 8.5 FP1, with SQL Server tables as your target, and thinking about upgrading to 8.5 FP2.

Kudos to you, cdp!

Was just about to start regression testing on a similar environment, but thought I'd check dsxchange first.