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!
Data caching - Commiting data batch wise
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 33
- Joined: Sun Jun 24, 2007 9:46 pm
-
- Participant
- Posts: 20
- Joined: Mon Dec 11, 2006 10:57 am
- Location: Pune
Re: Data caching - Commiting data batch wise
You have to set arraysize = 1 L and commit size = 1 L option.
Mayur Dongaonkar.
-
- Participant
- Posts: 33
- Joined: Sun Jun 24, 2007 9:46 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.