Installing the IBM Data Server Driver for JDBC and SQLJ as part of a Db2 installation

Installation of the IBM Data Server Driver for JDBC and SQLJ on your Db2 subsystem allows you to build and run Java database applications.

Before you begin

Prerequisites for the IBM Data Server Driver for JDBC and SQLJ:

  • An SDK for Java

    To find the minimum required Java Software Development kit (SDK) version for Db2 12, see Program directories for Db2 12.

    The IBM Data Server Driver for JDBC and SQLJ supports 31-bit or 64-bit Java applications.

    For stand-alone applications that require a 64-bit JVM, you need to install the IBM 64-bit SDK for z/OS®, Java 2 Technology Edition, V5 or later.

    For Java stored procedures and user-defined functions that require a 64-bit JVM, you need to install the IBM 64-bit SDK for z/OS, Java 2 Technology Edition, V6 or later.

  • TCP/IP

    TCP/IP is required on the client and all database servers to which you connect.

  • Db2 for z/OS distributed data facility (DDF) and TCP/IP support.
  • Unicode support for OS/390® and z/OS servers.

Procedure

To install the IBM Data Server Driver for JDBC and SQLJ, follow these steps:

  1. When you allocate and load the Db2 for z/OS libraries, include the steps that allocate and load the IBM Data Server Driver for JDBC and SQLJ libraries.
    See Jobs for loading the IBM Data Server Driver for JDBC and SQLJ libraries for details.
  2. On Db2 for z/OS, set subsystem parameter DESCSTAT to YES. DESCSTAT corresponds to installation field DESCRIBE FOR STATIC on panel DSNTIPF. This step is necessary for SQLJ support.
    See DESCRIBE FOR STATIC field (DESCSTAT subsystem parameter) for details.
  3. In z/OS UNIX System Services, edit your .profile file to customize the environment variable settings. You use this step to set the libraries, paths, and files that the IBM Data Server Driver for JDBC and SQLJ uses.
    You also use this step to indicate the versions of JDBC and SQLJ support that you need.

    See Environment variables for the IBM Data Server Driver for JDBC and SQLJ for details.

  4. Optional: Customize the IBM Data Server Driver for JDBC and SQLJ configuration properties.
    See Customization of IBM Data Server Driver for JDBC and SQLJ configuration properties for details.
  5. On Db2 for z/OS, enable the Db2 supplied stored procedures and define the tables that are used by the IBM Data Server Driver for JDBC and SQLJ.
    See Enabling the Db2-supplied stored procedures used by the IBM Data Server Driver for JDBC and SQLJ for details.
  6. In z/OS UNIX System Services, run the DB2Binder utility to bind the packages for the IBM Data Server Driver for JDBC and SQLJ.
    See DB2Binder utility for details.
  7. Verify the installation by running a simple JDBC application.
    See Verify the installation of the IBM Data Server Driver for JDBC and SQLJ for details.