DB2 Driver Update

Created by Sahith Chinthakindi on Fri, 10/28/2022 - 03:37
Published URL:
https://www.ibm.com/support/pages/node/6832728
6832728

Introduction

  • RBD JDBC client is not compatible with mainframe DB2 V12R1M504.
  • The latest jars will be a part of 9.7.0.1 fix pack release.
  • We have bundled db2 drivers in a plugin called com.ibm.etools.egl.sql.<build-version>.jar.

Steps to Extract DB2 Jar

  • Navigate to “IBMIMShared” folder.
    ${IBMIMShared}\plugins\com.ibm.etools.egl.sql.<build version>.jar.
  • Extract the plugin com.ibm.etools.egl.<build-version>.jar.
  • Inside this plugin, there is a folder with the name db2_driver.
  • Two Db2 driver jars are available in the db2_folder.

    image-20221028125144-1

  • db2jcc.jar (11.1 version)- This driver is based on the JDBC 3 specification (Minimum required Java version 4).
  • db2jcc4.jar (11.5 version)- This driver is based on the JDBC 4 or later specifications (Minimum required Java version 6).

Steps to Add jar in RBD

  1. There are no JARs added in the java build path.

    image-20221028125144-2

  2. To add jars, follow the below steps.
    1. Click Add External JARs.
    2. Navigate to the JARs location and add them
      E.g.:  C:\Program Files\ibm\IBMIMShared\plugins\com.ibm.etools.egl.sql_7.100.2.v20220824_1748.jar

      image-20221028125144-3

Page Feedback