DSXchange

Posted: **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

Posted: **Wed Nov 26, 2008 3:29 am**

you can use

Code: Select all

close command = commit;

in option properties

Posted: **Wed Nov 26, 2008 3:53 am**

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

Thanks!

Posted: **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".

DSXchange

Rows per transaction in ODBC stage

Rows per transaction in ODBC stage