transaction commit

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
dnat
Participant
Posts: 200
Joined: Thu Sep 06, 2007 2:06 am

transaction commit

Post by dnat »

Hi,

Is there an option to commit rows in a table through ODBC stage after 'n' number of transactions? Since our input data is large it is timing out in the odbc stage.
Top
sud
Premium Member
Premium Member
Posts: 366
Joined: Fri Dec 02, 2005 5:00 am
Location: Here I Am

Re: transaction commit

Post by sud »

Check this out :lol:
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.
Top
dnat
Participant
Posts: 200
Joined: Thu Sep 06, 2007 2:06 am

Post by dnat »

hi, i had posted this after searching the forum..but was not able to find any solution. As i am dealing with the 'Progress' database which i am connecting through ODBC i would not be able to use any environmental variables like ORA_COMMIT_INTERVAL etc.,
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

It always helps to mention your database. Which ODBC stage are you referring to, the Enterprise stage I assume? The pdf reference for that stage mentions a dboption of -rowCommitInterval you can use to control that, suggest you give that a read.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”