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.
Heads-up when installing 8.5 FP2
Moderators: chulett, rschirm, roy
Re: Heads-up when installing 8.5 FP2
Kudos to you, cdp!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.
Was just about to start regression testing on a similar environment, but thought I'd check dsxchange first.