JDBC Driver Installation for DB2 on z/OS - RESTRICTED

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 install directory

• Copy the DB2 on z/OS JDBC Driver (db2jcc.jar) to the folder: <DaticalDB_install_dir>/plugins
• Copy the DB2 on z/OS License File (db2jcc_license_cisuz.jar) to the folder: <DaticalDB_install_dir>/jre/lib/ext

Datical Desktop GUI - Driver Configuration

1. Remove the Old DB2 Driver
   1. If the original DB2 JDBC Driver has been installed in Datical, remove it from the plugins folder
      • remove file: <DaticalDB_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_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. 
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
      • 

Datical CLI - Driver Configuration

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

   • drivers=<DaticalDB_install_dir>/plugins

2. Test the database connection via the CLI

   1. hammer testconnect DEV

      

DB2 on z/OS is no longer supported with Datical DB.