BMC DASD MANAGER PLUS for DB2

Simplify and automate DB2 for z/OS object maintenance

Maintenance is typically the most mundane work DBAs do, while it is some of the most important. DBAs are under continual pressure to ensure high availability, maintain data integrity, and reduce costs. To address these issues, you may reorganize all databases on a schedule, whether the databases need reorganization or not, or you may not have a window to reorganize at all, and your databases could get so disorganized that they affect performance or even cause outages. How can you ensure that you are maintaining databases efficiently? 

BMC solution

BMC DASD MANAGER PLUS for DB2 collects and monitors statistics, determines which objects are out of compliance, develops a corrective action, and implements the corrective action automatically. It eliminates unnecessary reorganizations and ensures that objects are maintained efficiently. BMC DAST MANAGER PLUS for DB2 gathers statistics with no outage and with minimal impact to application processing.

Features and benefits

• Saves CPU resources by executing maintenance utilities only when required
• Increases application performance with up-to-date access path information to the DB2 optimizer
• Improves DB2 efficiency
• Increases application availability by eliminating any system downtime when gathering statistics

Key differentiators

• Flexible scheduling – Provides a scheduler and can work with your scheduler
• Reusability – Can replicate statistics standards and corrective procedures to multiple systems and subsystems after they are defined in one system
• Utility neutrality - Can generate corrective actions for IBM or BMC utilities

Related Products

• BMC Database Performance for DB2