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
Rows per transaction in ODBC stage
Moderators: chulett, rschirm, roy
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".
The Enterprise stage, set the "array size" to 1, then you will get an option to set the "row commit interval".
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>