Installing the z/OS Application Connectivity to Db2 for z/OS feature

z/OS Application Connectivity to Db2 for z/OS is a Db2 for z/OS feature. It allows IBM® Data Server Driver for JDBC and SQLJ type 4 connectivity from clients that do not have Db2 for z/OS installed to Db2 for z/OS or Db2 servers on Linux®, UNIX, or Windows.

Before you begin

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

  • IBM Java Technology Edition, version 8 or later.

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

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

About this task

To install the z/OS Application Connectivity to Db2 for z/OS, follow this process. Unless otherwise noted, all steps apply to the z/OS system on which you are installing z/OS Application Connectivity to Db2 for z/OS.

Procedure

To install the z/OS Application Connectivity to Db2 for z/OS feature:

  1. Allocate and load the z/OS Application Connectivity to Db2 for z/OS libraries.
  2. On all Db2 for z/OS servers to which you plan to connect, set subsystem parameter DESCSTAT to YES. DESCSTAT corresponds to installation field DESCRIBE FOR STATIC on panel DSNTIPF.

    This step is necessary for SQLJ support.

  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.
  4. On all Db2 for z/OS servers to which you plan to connect, enable the Db2-supplied stored procedures that are used by the IBM Data Server Driver for JDBC and SQLJ.
  5. In z/OS UNIX System Services, run the DB2Binder utility against the z/OS system on which you are installing z/OS Application Connectivity to Db2 for z/OS to bind the packages for the IBM Data Server Driver for JDBC and SQLJ at all Db2 for z/OS servers to which you plan to connect. You need to run DB2Binder once for each server.
  6. Verify the installation by running a simple JDBC application.