Environment variables for the z/OS Application Connectivity to Db2 for z/OS feature

You need to set environment variables so that the operating system can locate the z/OS Application Connectivity to Db2 for z/OS feature.

The environment variables that you must set are:

PATH

Modify PATH to include the directory that contains the shell scripts that invoke IBM® Data Server Driver for JDBC and SQLJ program preparation and debugging functions. If z/OS Application Connectivity to Db2 for z/OS is installed in /usr/lpp/jcct4v3, modify PATH as follows:

export PATH=/usr/lpp/jcct4v3/bin:$PATH

CLASSPATH

z/OS Application Connectivity to Db2 for z/OS contains the following class files:

db2jcc4.jar

Include db2jcc4.jar in the CLASSPATH to indicate that you are using the version of the IBM Data Server Driver for JDBC and SQLJ that includes JDBC 4.0 or later functions, and JDBC 3.0 or earlier functions.

sqlj4.zip

Include sqlj4.zip in the CLASSPATH to indicate that you plan to prepare SQLJ applications that include JDBC 4.0 or later functions, and JDBC 3.0 or earlier functions.

license-file-name

A license file that permits access to Db2 for z/OS servers.

Before version 4.34 of the IBM Data Server Driver for JDBC and SQLJ, the license file name is db2jcc_license_cisuz.jar. Starting with version 4.34 of the IBM Data Server Driver for JDBC and SQLJ, see the following table for the license file name.

License file name	Db2 Connect edition
db2jcc_license_consvZS.jar	Db2 Connect Unlimited Edition for System z
db2jcc_license_consvIS.jar	Db2 Connect Unlimited Edition for System i
db2jcc_license_consvAS.jar	Db2 Connect Application Server Edition
db2jcc_license_consvEE.jar	Db2 Connect Enterprise Edition
db2jcc_license_consvAAS.jar	Db2 Connect Application Server Advanced Edition
db2jcc_license_consvAZS.jar	Db2 Connect Unlimited Advanced Edition for System z

Modify your CLASSPATH to include these files. If z/OS Application Connectivity to Db2 for z/OS is installed in /usr/lpp/jcct4v3, modify CLASSPATH as follows:

export CLASSPATH=/usr/lpp/jcct4v3/classes/db2jcc4.jar:\
/usr/lpp/jcct4v3/classes/db2jcc_javax.jar:\
/usr/lpp/jcct4v3/classes/sqlj4.zip:\
/usr/lpp/jcct4v3/classes/license-file-name:\
$CLASSPATH