SQL Developer + DB2 for Z/OS

SQL Developer + DB2 for Z/OS

The easiest way to connect to Db2 is through their JDBC Type 4 JCC driver.
This driver uses two JARs:
db2jcc4.jar, which is the JDBC 4 driver (The db2jcc.jar JDBC 3 driver has been deprecated.)
db2jcc_license_cisuz.jar, which permits the driver to connect to all Db2 server platforms,
including z/OS

You need the binary driver jar files db2jcc.jar and db2jcc_license_cu.jar.

Configuring SQL Developer for DB2 Z/OS

  1. Download Oracle SQL Developer: https://www.oracle.com/database/sqldeveloper/technologies/download/
  2. Download appropriate version of DB2 JDBC Driver from IBM site: https://www.ibm.com/support/pages/db2-jdbc-driver-versions-and-downloads
  3. Start SQL Developer:
  4. Go to : Oracle SQL Developer/Tools/Preferences/Database/Third Party JDBC Driver
  5. Select location, and filename: db2jcc4.jar
  6. Select location, and filename: db2jcc_license_cisuz.jar

Adding DB2 Database Connections to SQL Developer

  1. Right-Click on: DB2 Connections
  2. Select: New Connection
  3. Enter Following Details:
    • Name: FTMPRODDB
    • Database Type: DB2
    • Authentication Type:
    • Username:
    • Password:
    • Hostname:
    • Port: 7282
    • Database: