StorageTek 312564001 User Manual
26
DB2 Manager User Guide
StorageTek
Proprietary
Resource type
Resource name
Access required
DATABASE LCDDB2
CREATETAB
TABLESPACE LCDDB2.LCDDB2TS
USE
OF
TABLE LCDDB2.PLAN_TABLE
SELECT,DELETE,
INSERT,UPDATE
INSERT,UPDATE
TABLE LCDDB2.REGISTRY
SELECT,DELETE,I
NSERT,UPDATE
NSERT,UPDATE
Member OTDBDEF in the distributed DB2 Manager JCL library supplies a job
to allocate and define this database, and to grant the above authorities. Edit
this member, following the instructions at the head of the member, and
submit the job. A copy of the supplied OTDBDEF job can be found in
appendix A of this manual.
to allocate and define this database, and to grant the above authorities. Edit
this member, following the instructions at the head of the member, and
submit the job. A copy of the supplied OTDBDEF job can be found in
appendix A of this manual.
b. Create DB2 Manager application plan.
DB2 Manager requires one or more DB2 plans for execution of its batch
utilities. Plan names are specified via the PLAN execution parameter for
each utility.
utilities. Plan names are specified via the PLAN execution parameter for
each utility.
It should be noted in this context that DBRMs shipped with the base product
or with service packages are created with the VERSION(AUTO) pre-compiler
option. This will allow multiple copies of the same package to be bound to a
single DB2 plan, to allow different versions of DB2 Manager programs to
execute using that plan. Alternatively, separate plans can be created and
execution controlled via use of the PLAN execution parameter.
or with service packages are created with the VERSION(AUTO) pre-compiler
option. This will allow multiple copies of the same package to be bound to a
single DB2 plan, to allow different versions of DB2 Manager programs to
execute using that plan. Alternatively, separate plans can be created and
execution controlled via use of the PLAN execution parameter.
Edit member OTDBPKG in the distributed DB2 Manager JCL library (file 3 on
the distribution tape). This contains JCL to create DB2 packages from
DBRMs supplied with the product. Instructions for editing the JCL are
provided at the top of the file.
the distribution tape). This contains JCL to create DB2 packages from
DBRMs supplied with the product. Instructions for editing the JCL are
provided at the top of the file.
After executing member OTDBPKG, edit and submit member OTDBPLAN in
the distributed DB2 Manager JCL library (file 3 on the distribution tape). This
contains JCL to create the application plan to be used by DB2 Manager and
to grant DB2 authorities for access to the plan. Again, instructions for editing
the JCL are provided at the top of the file.
the distributed DB2 Manager JCL library (file 3 on the distribution tape). This
contains JCL to create the application plan to be used by DB2 Manager and
to grant DB2 authorities for access to the plan. Again, instructions for editing
the JCL are provided at the top of the file.
A copy of the supplied OTDBPKG and OTDBPLAN jobs can be found in
appendix A of this manual.
appendix A of this manual.