Search code examples
databaseoracle-databasedb2mainframeoracle-sqldeveloper

DB2 database in Oracle SQL developer

I've heard it's possible to connect to a mainframe DB2 database with a client like Oracle SQL developer. I've looked on-line and can't seem to find the connector files needed to do this in SQL developer. Can anyone direct me to a link to make this work? Or tell me if im just looking for the wrong thing to begin with. I've got the connector working with MySQL databases in Oracle, so I assumed it would be similar for a DB2 database.

Solution

  • The easiest way to connect to Db2 is through their JDBC Type 4 JCC driver. This driver uses two JARs:

    1. db2jcc4.jar, which is the JDBC 4 driver (The db2jcc.jar JDBC 3 driver has been deprecated.)
    2. db2jcc_license_cisuz.jar, which permits the driver to connect to all Db2 server platforms, including z/OS

    Your mainframe DBA should be able to provide you with both of these JARs, and assist you in building a connect string with the proper JDBC driver options.

    More information about JDBC drivers for Db2 can be found here: https://www.ibm.com/support/pages/db2-jdbc-driver-versions-and-downloads