Implementing catalog indirection for ALTER, Catalog Manager, and Change Manager

Before you begin

Install ALTER, Catalog Manager, or Change Manager.

To implement catalog indirection

1. Submit the $729DOP1 and $730DOP2 jobs.
2. Submit the ADMIND00 job.This job creates an indirect JCL library, HLQ.INDssid.
3. Review the HLQ.INDssid($$INCIND) member and make any needed changes.This member contains the input values that the Installation System needs to create an indirect installation.
4. Run the $Znnxxxx jobs from HLQ.INDssid in the following order:
   1. $Z10COPY—This job copies configuration members used for indirection to the JCL library.
   2. $Z30DOPT—This job uses the DOPTS from your initial install and modifies it for indirection.
   3. $Z35COPY—This job creates a copy of the Db2 catalog.

   4. $Z38LOAD—This job unloads the real catalog, loads a copy of the catalog into new tables, and executes RUNSTATS on the newly loaded copy.

      Important

      This job uses worklist member INDLOAD to define the table spaces with a DSSIZE of 64 GB. Extended-addressability table spaces are required.

      If the $Z38LOAD job fails because of space issues, perform the procedure in To correct a failed $Z38LOAD job.

   5. $Z40INST—This job creates product aliases on the catalog indirection tables.
   6. $Z45COPY—This job updates the CONTAB table and copies stand-alone BIND jobs and the DOPTS modules to a user data set.
   7. (Optional) $Z60GRNT—This job grants the SELECT permission on the indirect catalog tables if an AUTHID was specified in the $$INCIND member.

5. Modify and validate the DB2 catalog access option on the BMCDB2PR panel in the HLQ.UBMCPLIB library.For instructions, see Customizing BMC products and solutions for Db2.

6. To invoke the products, run HLQ.UBMCCLIB(BMCDB2).
7. In the DB2 Catalog Access field, specify Indirect.

To correct a failed $Z38LOAD job

Use the following procedure to restart the $Z38LOAD job if it fails because of space issues:

1. Terminate the load utility that was running the worklist.
2. In the $Z38LOAD job, correct the space problem.
3. In the appropriate worklist, change the *GOTO command to -GOTO, and replace the worklist sequence number with the number of the UNLOAD statement that failed or that precedes the LOAD statement that failed.The LOAD statements use the REPLACE option.
4. Rerun the $Z38LOAD job.