BMC Software, Inc., Confidential and Proprietary Information
6-2 Administrative Products for DB2 Installation Guide
Overview
Overview
This chapter provides information about how to prepare to install the BMC
Software CATALOG MANAGER for DB2 product. The CATALOG
MANAGER product facilitates the day-to-day tasks that are associated with
DB2 administration. CATALOG MANAGER lets you access information in
a DB2 catalog by generating a list. Then, you can initiate an action on one or
more objects in the list. CATALOG MANAGER provides the following
major functions:
• creates new DB2 objects by using existing objects as a template
• drops catalog objects with the option to view a dependency list
• logs dropped object structures and their data for recovery purposes
• grants, revokes, and copies authorizations for users or objects
• lists revoked dependencies and reassigns authorizations
• executes BMC Software and DB2 utilities
• builds and issues DB2 commands
• logs user actions for an audit trail
• converts DBRM plans to use packages
• converts packages back to DBRM plans
• lists EXPLAIN command information for SQL tuning
• searches local and remote DB2 subsystem catalogs by using specific
search criteria to limit the retrieved object list
You do not need a thorough knowledge of DB2 structures or SQL syntax
because CATALOG MANAGER constructs the necessary SQL statements
from your input and selections and also maintains the database structures.
You choose when and how to execute the SQL statements. You can also store
frequently used SQL statements for future use.
For information about CATALOG MANAGER, read the CATALOG
MANAGER for DB2 User Guide.
You can install the UTILITY MANAGER product when you install
CATALOG MANAGER. For information about configuring UTILITY
MANAGER, refer to the UTILITY MANAGER for DB2 Getting Started
manual.
