Upgrading the IBM Data Server Driver for JDBC and SQLJ to a new version

Upgrading to a new version of the IBM Data Server Driver for JDBC and SQLJ is similar to installing the IBM Data Server Driver for JDBC and SQLJ for the first time. However, you need to adjust your application programs to work with the new version of the driver.

Before you begin

You should have already completed these steps when you installed the earlier version of the IBM Data Server Driver for JDBC and SQLJ:
  1. 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.
  2. 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.

About this task

Procedure

To upgrade the IBM Data Server Driver for JDBC and SQLJ to a new version, follow these steps:

  1. 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.
  2. Optional: Customize the IBM Data Server Driver for JDBC and SQLJ configuration properties.
  3. In z/OS UNIX System Services, run the DB2Binder utility to bind the packages for the IBM Data Server Driver for JDBC and SQLJ.
  4. Modify your applications to account for differences between the driver versions.
  5. Verify the installation by running a simple JDBC application.