Configure SQuirreL for DB2

db2 squirrel-sql
Thorsten Niehues picture Thorsten Niehues · Feb 10, 2017 · Viewed 32.8k times · Source

How to configure SQuirreL for DB2 access.

In SQuirreL I do see two DB2 drivers. But they are both marked with an red X.

I checked with Start Page but did not find an easy solution :/

Answer

Thorsten Niehues picture Thorsten Niehues · Feb 10, 2017
  1. Download the DB2 Driver from the IBM Website and extract the ZIP archive.
    Optionally you may want to copy it from the DB2 Server installation path:
    /opt/ibm/db2/V11.1/java/db2jcc4.jar
  2. Use db2jcc4.jar and copy it into the squirrel folder e.g. plugins/db2
  3. In der Driver in the tab "Extra Class Path" add the db2jcc4.jar file
  4. Change the class name to com.ibm.db2.jcc.DB2Driver

enter image description here

Related questions

How can I call a DB2 stored procedure with OUT parameters from SQuirreL SQL?

I really like SQuirreL SQL as a SQL query tool, but I've never been able to get it to call stored procedures in our AS/400 DB2 database. I always get the error "The number of parameter values set or registered …

Read More
Connect to IBM DB2 with SQuirreL "Reply.fill(). Message: Insufficient data. ERRORCODE=-4499, SQLSTATE=08001"

I have now tried 2 days to connect to external DB2 database with SQuirreL. I always get error: [jcc][t4][2030][11211][3.58.82] A communication error occurred during operations on the connection's underlying socket, socket input stream, or socket output stream. Error location: Reply.…

Read More
Configure SQuirrel SQL Client to work for DB2/AS400

I use the ancient System i Navigator (french) to get to query a DB2 (AS/400) database. I liked to update the client and use a more fresh (and English) sql client for that database. So, I installed the SQuirrel SQL …

Read More