JDBC Driver Installation for DB2 on z/OS

Overview

DB2 on z/OS requires that a specific JDBC driver and corresponding license file is setup in your environment to enable connectivity to the mainframe.

Installing the License File and Driver

Copy the following two jar files into the appropriate folders within your Liquibase Enterprise install directory

• Copy the DB2 on z/OS JDBC Driver (db2jcc4.jar) to the folder: <install_dir>/plugins

• Copy the DB2 on z/OS License File (db2jcc_license_cisuz.jar) to the folder: <install_dir>/repl/lib

Liquibase Enterprise Desktop GUI - Driver Configuration

1. Remove the Old DB2 Driver

   1. If the original DB2 JDBC Driver has been installed in Liquibase Enterprise, remove it from the plugins folder

      • remove file: <install_dir>/plugins/com.datical.db.drivers.db2_1.0.11.20181126111708.jar

2. Reference the DB2 Driver in the Preferences

   1. From the menu, select File → Preferences

   2. Navigate to the JDBC Drivers → IBM DB2 Drivers preferences page

   3. Click the Browse button and select the JDBC jar file (db2jcc.jar) in the <install_dir>/plugins directory

   4. Click the Validate button and make sure you see the "Successfully instantiated driver!" response.

      1. Click Apply

      2. Click OK to close the dialog

3. Test the Connection

   1. Assuming that you already have a database connection setup, click the Status button and verify that you don't get an error and that the Database Drum is Green

Liquibase EnterpriseCLI - Driver Configuration

1. Create a liquibaseenterprise.properties file (in a Liquibase Enterprise project directory) and add the following line pointing to the directory where you added the driver file (in step #1 above)

   • drivers=<install_dir>/plugins

2. Test the database connection via the CLI

   1. hammer testconnect DEV

      Open

      

Add {{db2jcc_license_cisuz.jar}} to the application class path

There are two avenues to add {{db2jcc_license_cisuz.jar}} to your application class path.

Environment Variable route

Specify a full path to the license jar in an environment variable with the name: DATICAL_DB2Z_LICENSE_JAR

In this example of a Linux setting, the path can be:
export DATICAL_DB2Z_LICENSE_JAR="/home/db2jcc_license_cisuz.jar"

It is important to note that the path can be different than the example above.

DATICAL_DB2Z_LICENSE_JAR allows the db2 license file to be visible for Liquibase Enterprise. When Liquibase Enterprise uses CLPPlus, and CLPPlus needs to see the DB2 license file, you need to set the CLASSPATH environmental variable to the same value as DATICAL_DB2Z_LICENSE_JAR.

License Jar Directory route

Place the license JAR file name db2jcc_license_cisuz.jar into a default directory located here: $INSTALL_DIR/repl/lib

The complete license jar directory route will look like this:

$INSTALL_DIR/repl/lib/db2jcc_license_cisuz.jar