This week's book giveaway is in the Design forum.
We're giving away four copies of Design for the Mind and have Victor S. Yocco on-line!
See this thread for details.
Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

upgrade to database causes memory fault when running app

 
Marilyn de Queiroz
Sheriff
Posts: 9059
12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34178
340
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Marilyn,
I'm confused. The pre-db2 8 driver from IBM isn't working with db2 8? Or am I reading the question wrong.

If this is it, I wouldn't be surprised. You often have to upgrade drivers when a new version of the database comes out. Especially for vendor supplied drivers.
 
Marilyn de Queiroz
Sheriff
Posts: 9059
12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Well, it's a different driver. In theory they are both supposed to work with DB2 v8. In actuality, the old driver works with most apps and not with some apps and the new driver works with most apps (including the ones driver #1 doesn't) and not with some other apps (that driver #1 works with). Very frustrating.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic