Using Commit in DataStage
Moderators: chulett, rschirm, roy
Using Commit in DataStage
Hi, i'm trying to use the commit in a ODBC stage, because the quantity of records are very big and make me slow the server, and if by some reason the execution failed the rollback take a lot of time to do, what i'm tring to do is taking a numbers of records and make the commit, write another group of records and make the commit, can some one helpe me please.....thanks. :D
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Find the "rows per transaction" setting. This configures a value N which causes DataStage to issue a COMMIT request for each N rows that have been sent to the database server.
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.
-
- Participant
- Posts: 32
- Joined: Wed Dec 28, 2005 9:02 pm