Enabling the Db2-supplied stored procedures used by the IBM Data Server Driver for JDBC and SQLJ

The IBM Data Server Driver for JDBC and SQLJ requires a set of stored procedures to make certain methods work on Db2 for z/OS®.

Before you begin

WLM must be installed on the z/OS system, and a WLM environment must be set up for running the Db2-supplied stored procedures that are required by the IBM Data Server Driver for JDBC and SQLJ.

About this task

The stored procedures that you need to install are:
  • SQLCOLPRIVILEGES
  • SQLCOLUMNS
  • SQLFOREIGNKEYS
  • SQLFUNCTIONCOLS
  • SQLFUNCTIONS
  • SQLGETTYPEINFO
  • SQLPRIMARYKEYS
  • SQLPROCEDURECOLS
  • SQLPROCEDURES
  • SQLPSEUDOCOLUMNS
  • SQLSPECIALCOLUMNS
  • SQLSTATISTICS
  • SQLTABLEPRIVILEGES
  • SQLTABLES
  • SQLUDTS
  • SQLCAMESSAGE

Procedure

Follow these steps to install the stored procedures:

  1. Set up a WLM environment for running the stored procedures.

    Define WLM application environment DSNWLM_GENERAL to WLM. Application environment DSNWLM_GENERAL and its associated JCL startup procedure, DSNWLMG, are created during Db2 installation. DSNWLM_GENERAL is designed for running the Db2-supplied stored procedures that support JDBC.

  2. Define the stored procedures to Db2, and bind the stored procedure packages.

    To perform those tasks, use job DSNTIJRT.