Versions Compared

Old Version 3

changes.mady.by.user Former user

Saved on

compared with

New Version Current

changes.mady.by.user Amber Williams

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Panel
bgColor#F0F0F0

Table of Contents

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 Datical Liquibase Enterprise install directory

  • Copy the DB2 on z/OS JDBC Driver (db2jccdb2jcc4.jar) to the folder: <DaticalDB<install_install_dir>/plugins
  • Copy the DB2 on z/OS License File (db2jcc_license_cisuz.jar) to the folder: <DaticalDB<install_install_dir>/jrerepl/lib/ext

...

Liquibase Enterprise Desktop GUI - Driver Configuration

  1. Remove the Old DB2 Driver
    1. If the original DB2 JDBC Driver has been installed in DaticalLiquibase Enterprise, remove it from the plugins folder
      • remove file: <DaticalDB_install<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 <DaticalDB<install_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 daticaldba liquibaseenterprise.properties file (in a Datical Liquibase Enterprise project directory) and add the following line pointing to the directory where you added the driver file (in step #1 above)

    • drivers=<DaticalDB<install_install_dir>/plugins

  2. Test the database connection via the CLI

    1. hammer testconnect DEV

...


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