Setting up the environment for Java routines

Before you can run Java routines, you need to set up a WLM environment and set Java environment variables.

Before you begin

Before you can prepare and run Java routines, you need to satisfy the following prerequisites:
  • IBM Java Technology Edition, version 8 or later. The IBM® Data Server Driver for JDBC and SQLJ supports 31-bit or 64-bit Java routines. For more information, see Moving from 31-bit Java routines to 64-bit Java routines.

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

  • The 4.xx version of the IBM Data Server Driver for JDBC and SQLJ that matches the Db2 for z/OS® version.

    If you are migrating from a previous release of Db2 for z/OS, you need to install the corresponding version of the IBM Data Server Driver for JDBC and SQLJ.

About this task

The steps in this task are necessary for preparing and running Java routines.

If you plan to use IBM Db2 for z/OS Developer Extension to prepare and run your Java routines, see Deploying and running external Java and SQLJ stored procedures.

Procedure

To set up the environment for running Java routines, you need to perform these tasks:

  1. Ensure that your operating system, SDK for Java, and the IBM Data Server Driver for JDBC and SQLJ are at the correct levels, and that you have installed all prerequisite products.

    Important: If you have migrated the Db2 subsystem from a previous release of Db2 for z/OS, your existing Java stored procedures and user-defined function no longer work with the previous release of the IBM Data Server Driver for JDBC and SQLJ and the current release of Db2 for z/OS. You need to install the version of the IBM Data Server Driver for JDBC and SQLJ that matches the Db2 for z/OS release level, and update the WLM-managed stored procedure address space configuration and JAVAENV data set to use the current driver.

  2. Create the Workload Manager for z/OS (WLM) application environment for running the routines.
  3. Set up the run-time environment for Java routines, which includes setting environment variables.