EasyManuals Logo

IBM DB2 User Manual

IBM DB2
585 pages
To Next Page IconTo Next Page
To Next Page IconTo Next Page
To Previous Page IconTo Previous Page
To Previous Page IconTo Previous Page
Page #437 background imageLoading...
Page #437 background image
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

Table of Contents

Questions and Answers:

Question and Answer IconNeed help?

Do you have a question about the IBM DB2 and is the answer not in the manual?

IBM DB2 Specifications

General IconGeneral
DeveloperIBM
Initial Release1983
LicenseProprietary
Written inC, C++
CategoryDatabase Management System (RDBMS)
Operating SystemLinux, Windows
Programming LanguagesC, C++
Data ModelsRelational
EditionsCommunity, Standard, Advanced
Key Featureshigh availability, scalability