 |
 |
DATA SHEET |
 |
| BMC® CATALOG MANAGER for DB2 |
|
> Automates administrative tasks and provides accuracy with the ability to invoke utilities, DDL, DCL, DML and DB2 commands directly from lists
> Reduces DB2 learning curve and improves productivity by providing easy-to-use menus and dialogs
> Provides utility profiles for productivity and reduction in errors
> Provides facility for creating, editing, and browsing DB2 tables and views
> Streamlines security management and simplifies access to DB2 security information
> Provides an audit trail for catalog-based actions through audit, drop-recovery and session logs
> Provides DB2 version 8 support
BMC Software solution
A product is needed that can satisfy all levels of DB2 users. That product is the BMC CATALOG MANAGER for DB2 product. Novice users benefit from CATALOG MANAGER because they can use its menus and lists to navigate through the DB2 catalog. Experienced database administrators (DBAs) benefit because they can use a single tool to perform a multitude of functions.
Increases productivity and accuracy
CATALOG MANAGER provides interactive access to catalog information through menus, dialogs and online help. But locating the information in the DB2 catalog is only the first step. CATALOG MANAGER automates many of the administrative functions by allowing you to invoke utilities, and execute data definition language (DDL), data control language (DCL), data manipulation language (DML), and DB2 commands directly from CATALOG MANAGER lists.
You no longer have to remember SQL syntax or code JCL. CATALOG MANAGER does it for you. And because it is automated, it is accurate. You no longer have to locate every dependency or plan affected by a change. CATALOG MANAGER finds and displays this kind of information. CATALOG MANAGER allows you to easily:
> create and drop DB2 objects
> grant, revoke or copy authorizations
> convert or manage plans, packages or DBRMs
> perform BIND, REBIND and FREE functions
> build and issue DB2 commands
> execute BMC Software or IBM DB2 utilities
Reduces learning curve and costs
CATALOG MANAGER facilitates navigation through the DB2 catalog. It highlights information on relationships, dependencies and the hierarchy of DB2 objects. CATALOG MANAGER reduces development costs by:
> processing SQL statements, DB2 commands, DSN commands, and BMC Software and IBM utilities directly from generated lists
> eliminating the need to know SQL syntax, thereby decreasing the DB2 learning curve and increasing productivity of new developers and allowing experienced DBAs and developers to perform many tasks quickly
> cloning existing objects for use as test objects
> providing advanced utility processing, which lets you specify and execute up to eight utilities against one or more objects
> providing combined lists; for example, when your DB2 environment contains ERP applications with large numbers of objects, CATALOG MANAGER gives you the ability to combine a table space list and a package list in order to view all packages in the listed table spaces
Stores utility preferences
CATALOG MANAGER allows you to store utility preferences in a profile. A utility profile is a file that contains customized specifications. Using utility profiles saves time and helps avoid user errors because you avoid having to specify the utility syntax each time you generate a job. There are two kinds of profiles:
> site profile, which is available to all users
> user profile, which is available to the user who creates it
Integrates a table editor
DBAs and application developers can easily create, edit and browse DB2 tables and views using the integrated table editor in CATALOG MANAGER. Users can mark and move, delete, copy or repeat, undo and select single or multiple rows. Users familiar with ISPF editing will find the table editor intuitive and easy to use. Added security features allow the DBA to control who has the ability to use the table editor.
Eases security burden
CATALOG MANAGER streamlines security administration. It is 100% compatible with DB2 security mechanisms, offering only safe and secure shortcuts. CATALOG MANAGER eases the security burden by:
> automating the grant and revoke process with fill-in-the-blank panels
> determining the effects of a REVOKE and optionally reassigning authorizations from one user to another
> copying authorizations from one object to another or from one user to another
Develops an audit trail
CATALOG MANAGER creates an automatic audit trail for all catalog-based actions through three types of logs: audit, drop-recovery and session.
The audit log satisfies many corporate audit requirements by identifying who executed a DDL function, when it was executed and on what object. The drop recovery log offers added security by providing the ability to easily recover dropped objects and data. The session log lists all command executions by user and session. This serves as a training aid by eliminating the need to write out step-by-step procedures.
Provides DB2 version 8 support
CATALOG MANAGER provides support for DB2 for z/OS version 8. Support includes, but is not limited to the following:
> Greater than 254 partitions
> Variable CI size
> Nonpadded indexes
> Unicode data
> Longer SQL statements
> Online schema (OLS) changes
> Long object names
> Materialized Query Tables (MQTs)
> Table-controlled partitioning
> Data-partitioned secondary indexes (DPSIs)
BMC Database Administration for DB2 solution and BMC Administrative Assistant for DB2 solution
CATALOG MANAGER is available as a standalone product or as a component in the BMC Database Administration for DB2 solution and the BMC Administrative Assistant for DB2 solution.
The Database Administration solution provides effective and timely management of growth and change in an increasingly complex database environment.
The Administrative Assistant solution helps users of varying experience quickly navigate through the DB2 catalog.
Helping you maintain advantage
BMC Software Education Services offers a strategic investment for your business, maximizing the value for your employees and Business Service Management initiatives. Education ensures successful product implementation, promoting mastery of all product capabilities and highest productivity with your BMC Software solutions. To explore our education offerings, visit our web page at http://www.bmc.com/bmceducation, or contact BMC Software Education Services by telephone or e-mail:
> North America
Telephone: 800 574 4262
E-mail: education@bmc.com
> Asia Pacific
Telephone: +61 3 9657 4404
E-mail: ap_education@bmc.com
> Europe, Middle East, and Africa (EMEA)
Telephone: 00800 26233822
E-mail: emea_education@bmc.com
About BMC Software
BMC Software, Inc. [NYSE:BMC] is a leading provider of enterprise management solutions that empower companies to manage their IT infrastructure from a business perspective. Delivering Business Service Management, BMC Software solutions span enterprise systems, applications, databases and service management. Founded in 1980, BMC Software has offices worldwide and fiscal 2005 revenues of more than $1.46 billion. For more information about BMC Software, visit www.bmc.com.