BMC CATALOG MANAGER for DB2

Simplify DB2 for z/OS catalog management

To be productive, DBAs and application programmers must understand the DB2 catalog and directory, create objects, drop objects, BIND plans, FREE plans, execute SQL, create utility jobs, prepare DDL and DCL, and perform security administration. They need a robust and flexible product that can quickly navigate through the DB2 catalog, without needing to know the complex SQL required to find what they are looking for. 

BMC solution

BMC CATALOG MANAGER for DB2 automates the tedious, error-prone tasks of creating and dropping objects, maintaining user privileges, generating DB2 utility JCL, and executing DB2 commands. With BMC CATALOG MANAGER for DB2, you don’t need extensive knowledge of the DB2 catalog table structure or the SQL that is required to query the DB2 catalog.

Features and benefits

• Simplifies DB2 catalog navigation and change management, offers multiple ways to find information in the catalog, and provides extensive catalog reports
• Imports, edits, generates, tests, and analyzes SQL
• Logs all DB2 catalog changes - provides an audit of DB2 catalog activity and enables drop recovery logging – quickly restore the log, a common mistake
• Connects to any DB2 subsystem using DDF (distributed database facility)

Key differentiators

• Allows you to recover inadvertently dropped DB2 objects
• Includes an integrated table editor
• Supports BMC and IBM DB2 utilities
• Allows you to create and save utility profiles to set utility syntax at the site or user level

Related Products

• BMC Database Administration for DB2