Rows per transaction in ODBC stage

gomez · Post by **gomez** » Wed Nov 26, 2008 12:42 am

Hi:
We are loading about 8555555 records into a DB2 table in a Parallel job. I get an error "transaction log is full". Looks like if I do a frequent commit while the data load is happening, I might not get this error.
However I am not able to find a property like "Rows per transaction" in the ODBC stage in Parallel job. Am I missing something?
Appreciate any inputs/suggestions on this!
Thanks

Scope · Post by **Scope** » Wed Nov 26, 2008 3:29 am

you can use

Code: Select all

close command = commit;

in option properties

gomez · Post by **gomez** » Wed Nov 26, 2008 3:53 am

Say if I want to commit every 10000 rows, what should I do?

Thanks!

ArndW · Post by **ArndW** » Wed Nov 26, 2008 6:25 am

The ODBC connector at Version 8 has a "transaction -> record count" value that you can set.

The Enterprise stage, set the "array size" to 1, then you will get an option to set the "row commit interval".