Tuesday, January 5, 2010

Download DB2 Drivers

I am using the SQuirreL SQL Client 2.6.9 for connecting to our DB2 db. I went through lot of issues to make it work. All the issues were cleared once I downloaded the latest DB2 client from this link IBM Data Server Client

The client installation will create a SQLLIB folder under IBM in Program Files. The SQLLIB folder has a java folder which has the db2java.zip. This zip is needed for IBM DB2 App Driver to work.

For the IBM DB2 Net Driver you need to put db2jcc.jar and db2jcc_license_cu.jar (both in the java folder) in the extra class path of the SQuirreL client.

One of the issues that was fixed with the new client is this :
  • the driver being used is not jdbc 2.1 compliant (this is because of the older SQLLIB i got from a colleague, before installing the client)