BMC Database Administration for DB2

Simplify DB2 for z/OS database administration

Critical applications depend on DB2 for z/OS. Explosive data growth, a shrinking workforce, and the ability to respond to the needs of critical DB2 applications all affect availability and integrity. Implementing changes is risky, and managing the DB2 environment can be challenging. DBAs must be able to manage object and schema changes (and all underlying changes), navigate the DB2 catalog, and perform administrative tasks such as unloading, loading, and copying objects – all while maintaining availability and data integrity.

BMC solution

BMC Database Administration for DB2 improves DBA productivity by providing intelligent automation for all DB2 for z/OS environments, including those driven by ERP/CRM, data warehouse, and Internet applications. It increases application availability and optimizes resources by reducing the time required to administer multiple DB2 environments, while providing application and data integrity. BMC Database Administration for DB2 provides catalog and change management tools and high speed utilities to support objects throughout the application life cycle with automation and reliability. BMC Database Administration for DB2 consists of the following products:

• BMC CHANGE MANAGER for DB2
• BMC CATALOG MANAGER for DB2
• BMC UNLOAD PLUS for DB2
• BMC LOADPLUS for DB2
• BMC COPY PLUS for DB2
• BMC SNAPSHOT UPGRADE FEATURE

Features and benefits

• Improves DB2 object availability and integrity by managing changes with integrity and performing maintenance with minimal outages
• Reduces costs of unloading, loading, and copying DB2 data by managing its own buffering and performs I/O operations at the lowest level possible, avoiding unnecessary processing by processing objects in one pass, running outside of DB2, and eliminating the need to execute the RUNSTATS utility, sort data, and reorganize indexes separately
• Improves productivity by simplifying DB2 catalog navigation and change management, and by providing an integrated table editor
• Mitigates risk by synchronizing changes with related objects

Key differentiators

• Enables version control - can roll changes forward or back as needed
• Allows you to recover inadvertently dropped DB2 objects, can recreate structure, authorizations and data
• Automatically calculates optimal work file sizes and dynamically allocates work file and copy data set space
• Provides dynamic allocation, automatic restart, and automated error correction
• Avoids failure when resources are unavailable (Automatic Retry). Automatically recovers and restarts failed copy jobs.
• Provides the ability to back out changes
• Includes an integrated table editor