Filter
Top Products
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
TABLE LCDDB2.REGISTRY SELECT,DELETE,I
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.
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.
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.
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.
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.
A copy of the supplied OTDBPKG and OTDBPLAN jobs can be found in
appendix A of this manual.