BMC Software, Inc., Confidential and Proprietary Information
3-22 Administrative Products for DB2 Installation Guide
Using Catalog Indirection
Synonym Qualifiers, Default Options, and Plan Names
When one of the Administrative Products runs, it uses its own DOPTs
module that was built during installation. The BMCDB2 CLIST allocates the
DOPTs module name when you start the product. When you request indirect
access, the product allocates a DOPTs module that is different from the direct
access options module. Contained in this DOPTs module are the plans that
are used when certain product functions are executed.
Note: CATALOG MANAGER 3.3 or later uses a single DOPTs module for
both direct access and indirect access. The BMCDB2 CLIST
allocates the same DOPTs module and the same plan for direct
access and indirect access. The plan that is accessed contains two
distinct collection IDs that are used to access direct or indirect
catalogs.
The qualifier of the plan and the packages is used to resolve synonyms that
point to either a view of the DB2 catalog or a copy of the DB2 catalog,
depending on the method of implementation.
The DOPTs module, the plan and collection names, and the synonym
qualifier are all crucial for the implementation of catalog indirection. You
should understand their use and interaction before you implement catalog
indirection.
Note: To help maintain catalog indirection, follow the naming conventions
described on page 3-23. Naming conventions enable you to look at
the DOPTs module or allocated plan and determine whether indirect
access or direct access is being used.
The Install System uses a
<--- C-I Parm indicator to mark values that must be
different from the direct access specification. When you see this indicator,
supply unique names.
Creating Collection Names for Multiple Indirect Catalogs
With CATALOG MANAGER 3.4 or later, you can have more than one
indirect catalog. Each indirect catalog requires a unique collection name.
Also, you can assign a collection name alias.
See Chapter 6, “Installing CATALOG MANAGER,” for information about
implementing catalog indirection with this product.
