Search code examples
db2squirrel-sql

Configure SQuirreL for DB2


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 :/


Solution

    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