Page 1 of 1
Using Commit in DataStage
Posted: Fri Apr 21, 2006 3:33 pm
by avidal18
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
Posted: Fri Apr 21, 2006 3:43 pm
by ray.wurlod
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.
Posted: Fri Apr 21, 2006 3:55 pm
by avidal18
Thank you very much Ray, i find it.
Regards.
Angel.
Posted: Sun Aug 13, 2006 10:01 pm
by chowmunyee
avidal18 wrote:Thank you very much Ray, i find it.
Regards.
Angel.
Is is avidal18's question is is called batch commit?