The APPLENV value must match the value that you specify in the WLM
address space startup procedure and on the CREATE PROCEDURE statements
for the stored procedures.
Limit on starting server address spaces for a subsystem instance
Specify 1 (no limit).
Related tasks
“Creating the WLM address space startup procedure for the IBM Data Server
Driver for JDBC and SQLJ stored procedures” on page 419
Jobs for creating IBM DB2 Driver for JDBC and SQLJ stored
procedures and tables
DB2 provides JCL jobs that include statements that you can use to define the
DB2–supplied stored procedures for JDBC, bind the stored procedure packages,
and define the SYSIBM.SYSDUMMYU, SYSIBM.SYSDUMMYA, and
SYSIBM.SYSDUMMYE tables.
DSNTIJSG
Use this job if you are defining the stored procedures and tables as part of
installing or migrating a DB2 subsystem.
Before you run this job, you need to modify the WLM ENVIRONMENT
parameter value for each stored procedure to match the Application
Environment Name value that you specified in the WLM panels and the
APPLENV name that you specified in the WLM address space startup
procedure. Other customizations are made as part of the installation process.
DSNTIJMS
Use this job if you are defining the stored procedures and tables after you
install or migrate a DB2 subsystem.
Before you run this job, you need to make the modifications that are described
in the job prolog.
DB2Binder utility
The DB2Binder utility binds the DB2 packages that are used at the database server
by the IBM Data Server Driver for JDBC and SQLJ, and grants EXECUTE authority
on the packages to PUBLIC. Optionally, the DB2Binder utility can rebind DB2
packages that are not part of the IBM Data Server Driver for JDBC and SQLJ.
DB2Binder syntax
java com.ibm.db2.jcc.DB2Binder -url jdbc : db2 : // server / database
: port
-user user-ID -password password
-size integer
-collection collection-name
,
-tracelevel trace-option
-action add
-action replace
-action drop
-action rebind
Chapter 8. Installing the IBM Data Server Driver for JDBC and SQLJ 421