Installing the JDBC driver for setting up a remote DB2 database

Depending on which operating system the remote DB2® is installed on, you need the following files:

  • DB2 for Linux, or AIX:
    • db2jcc.jar
    • db2jcc_license_cu.jar: License file for DB2 for Linux, or AIX
    You can find these files in the <DB2_install_home>/sqllib/java directory.
  • DB2 for z/OS®
    • db2jcc.jar
    • db2jcc_license_cisuz.jar: License file for DB2 for z/OS
    You can find these files in the subdirectory classes or jcc/classes of the DB2 JDBC installation directory in the HFS.
    Note: The IBM DB2 driver for JDBC and SQLJ needs to be installed separately, after you have installed DB2 for z/OS.
You have the following options to install the JDBC driver:
  • Create a new folder. Copy the files listed above into this folder. Point the installer to the directory as described in Starting the SMU Automation installer.
  • Use the WebSphere® JDBC driver: Copy the appropriate .jar files into the directory <was_home>/universalDriver/lib, if not already available. Point the installer to the directory as described in Starting the SMU Automation installer.
  • Use the DB2 runtime client JDBC driver: Point the installer to the directory with the appropriate .jar files as described in Starting the SMU Automation installer.