We were using COM.ibm.db2.jdbc.app.DB2Driver (a type-2 driver). It was working fine with this driver until an upgrade to the database (to DB2 v8). But now it's causing a memory fault when using the original driver.
So we switched to com.ibm.db2.jcc.DB2Driver (using as a type-2 driver) which does not cause the memory fault.
The app copies from a table in one database and writes to an identical table in a different database.
I tried (with the old driver) increasing the JVM memory from 128 to 384m. I also tried decreasing the batch write size from 400 to 100. Neither change resolved the problem. Only using the new driver resolved the issue.
Does anyone have any ideas about could be happening here?
So we switched to com.ibm.db2.jcc.DB2Driver (using as a type-2 driver) which does not cause the memory fault.
The app copies from a table in one database and writes to an identical table in a different database.
I tried (with the old driver) increasing the JVM memory from 128 to 384m. I also tried decreasing the batch write size from 400 to 100. Neither change resolved the problem. Only using the new driver resolved the issue.
Does anyone have any ideas about could be happening here?