IBM DB2 User Manual

v SQLUDTS
v SQLCAMESSAGE
The tables that you need to create are:
v SYSIBM.SYSDUMMYU
v SYSIBM.SYSDUMMYA
v SYSIBM.SYSDUMMYE
Those tables ensure that character conversion does not occur when Unicode data is
stored in DBCLOB or CLOB columns.
Follow these steps to install the stored procedures and create the tables:
1. Set up a WLM environment for running the stored procedures.
To set up a WLM application environment for these stored procedures, you
need to define a JCL startup procedure for the WLM environment, and define
the application environment to WLM.
2. Define the stored procedures to DB2, bind the stored procedure packages, and
define the SYSIBM.SYSDUMMYU, SYSIBM.SYSDUMMYA, and
SYSIBM.SYSDUMMYE tables.
Related tasks
“Installing the z/OS Application Connectivity to DB2 for z/OS feature” on
page 435
Chapter 9, “Migrating from the JDBC/SQLJ Driver for OS/390 and z/OS to the
IBM Data Server Driver for JDBC and SQLJ,” on page 439
“Upgrading the IBM Data Server Driver for JDBC and SQLJ to a new version”
on page 434
Creating the WLM address space startup procedure for the IBM
Data Server Driver for JDBC and SQLJ stored procedures
You can use the DSN8WLMP sample startup procedure as a model for your stored
procedure address space startup procedure.
Make the following changes to that stored procedure:
1. Change the APPLENV value to match the definition name that you specify in
the WLM Definition Menu.
2. Change the startup procedure name to match the procedure name that you
specify in the WLM Create an Application Environment menu.
3. Change the DB2SSN value to the subsystem name of your DB2 for z/OS
subsystem.
4. Edit the data set names to match your data set names.
Related concepts
“Values for the WLM environment for IBM Data Server Driver for JDBC and
SQLJ stored procedures”
Values for the WLM environment for IBM Data Server Driver for
JDBC and SQLJ stored procedures
You need to define the application environment that you use for DB2-supplied
stored procedures for the IBM Data Server Driver for JDBC and SQLJ to WLM.
Chapter 8. Installing the IBM Data Server Driver for JDBC and SQLJ 419

IBM DB2 Specifications

General

Developer	IBM
Initial Release	1983
License	Proprietary
Written in	C, C++
Category	Database Management System (RDBMS)
Operating System	Linux, Windows
Programming Languages	C, C++
Data Models	Relational
Editions	Community, Standard, Advanced
Key Features	high availability, scalability