StorageTek 312564001 manual Resource type Resource name Access required

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.

26	DB2 Manager User Guide
	StorageTek Proprietary