DSXchange

Posted: **Fri Sep 14, 2007 1:36 am**

Hi,

I have to insert close to 10lakh into oracle database. The datastage caches all 10 lakh records and then inserts and performs a commit ....

Now what I wanna do is that , the insertion should happen for very 1 lakh records and a COMMIT should be performed at this stage ...

Kindly let me know if there is any solution asap.

Cheers!

Posted: **Fri Sep 14, 2007 5:56 am**

You have to set arraysize = 1 L and commit size = 1 L option.

Posted: **Fri Sep 14, 2007 6:04 am**

Arraysize = 1 L and commit size = 1 L option or found only in Oracle OCI stage (i.e server jobs)

Can u please guide me how do I handle the same with server Jobs

Posted: **Fri Sep 14, 2007 2:58 pm**

Make up your mind. You posted in the parallel forum with a job type marked as parallel. Now, you ask for a server answer. To get that, post your question in the server forum.

DSXchange

Data caching - Commiting data batch wise

Data caching - Commiting data batch wise

Re: Data caching - Commiting data batch wise