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:
- Java 2
Technology Edition, V5 or later
The IBM Data Server Driver for JDBC and
SQLJ supports
31-bit or 64-bit Java applications.
If
your applications require a 64-bit JVM, you need to install the IBM 64-bit SDK for z/OS, Java 2
Technology Edition, V5 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.
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:
-
Allocate and load the z/OS Application Connectivity to Db2 for
z/OS
libraries.
-
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.
-
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.
-
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.
-
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.
-
Verify the installation by running a simple JDBC application.