Install the JDBC Driver for LUW and DB2 on z/OS

An installed JDBC driver is required for both LUW and DB2 on z/OS to enable connectivity to the mainframe. DB2 on z/OS also requires a corresponding license file environment variable to complete the connection.

Install the Driver

  1. Copy the driver jar file into the appropriate folder within your Liquibase Enterprise install directory. You may use your own custom driver or the one we provide on update.liquibase.com.
    • Copy the DB2 on z/OS JDBC Driver (db2jcc.jar or your_custom_driver) to the folder: <Enterprise_install_dir>/plugins

Tip: For more info about installing drivers on Windows or Linux, navigate to the documentation listed below:
Install Database Drivers on Windows Systems
Install Enterprise and Drivers on Linux Systems

Install and Setup the License File

Note: This variable is used only for DB2 on z/OS.

The db2jcc_license_cisuz.jar file is not included in the Liquibase Enterprise download, so you must install and set it up separately. You must setup an environment variable that represents the license file for DB2 and Liquibase Enterprise to communicate to each other. Follow these steps to establish the license file as an environment variable successfully.

  1. Obtain the license file from IBM's website.
  2. Set up an environment variable called DATICAL_DB2Z_LICENSE_JAR to represent the license file.
    Set an Environment Variable on Linux
    Set an Environment Variable on Windows
  3. Verify that the Environment Variable is established successfully by running the following command in the CLI.
    Linux: echo $DATICAL_DB2Z_LICENSE_JAR
    Windows: echo %DATICAL_DB2Z_LICENSE_JAR%

Liquibase Enterprise Desktop GUI - Driver Configuration

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 or your_custom_driver) in the <Enterprise_install_dir>/plugins directory.
  4. Click the Validate button and ensure the "Successfully instantiated driver!" response appears.
    • Click Apply.
    • Click OK to close the dialog.
  5. Test the Connection

    6. 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.

Enterprise CLI - Driver Configuration

  1. Create an enterprise.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)

    2. drivers=<enterprise_install_dir>/plugins

  2. Test the database connection via the CLI

    3. hammer testconnect DEV