StorageTek 312564001 用户手册

 

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. 

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.