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:
- 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.
- Define the stored procedures to Db2, and bind the stored procedure
packages.
To perform those tasks, use job DSNTIJRT.