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)
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.
26 | DB2 Manager User Guide |
| StorageTek Proprietary |