Heads-up when installing 8.5 FP2

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
cdp
Premium Member
Premium Member
Posts: 113
Joined: Tue Dec 15, 2009 9:28 pm
Location: New Zealand

Post by cdp »

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.
Top
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

Thanks for the tip!
Choose a job you love, and you will never have to work a day in your life. - Confucius
Top
surfsup2
Participant
Posts: 4
Joined: Fri Feb 24, 2012 4:01 am

Re: Heads-up when installing 8.5 FP2

Post by surfsup2 »

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.
Top
Post Reply

Return to “General”