BMC Database Performance for DB2

Automate DB2 reorganizations. Improve performance and availability.

Because so many critical applications depend on DB2, it is important to keep DB2 databases online performing optimally. Over time, insert, delete, and update activity cause DB2 table spaces and indexes to become disorganized. Disorganized databases lead to transaction and batch performance degradation. How can you ensure availability while maintaining data integrity?

BMC solution

BMC Database Performance for DB2 automates database maintenance and reduces unnecessary CPU cycles.  It determines which maintenance tasks are required and can execute those tasks automatically. BMC Database Performance for DB2 uses triggers and statistics to generate reorganizations of the data only when needed and can execute reorganizations without disrupting application access to the data. Integration with BMC SQL Performance for DB2 provides even more automation. BMC Database Performance for DB2 consists of the following products:

• BMC DASD MANAGER PLUS for DB2
• BMC REORG PLUS for DB2
• BMC SNAPSHOT UPGRADE FEATURE for DB2

Features and benefits

• Reduces cost by reducing unnecessary reorganization processing.
• Improves performance of reorganizations with more efficient high speed utility processing
• Improves availability with online reorganization (you have full access to application data) and faster processing
• Improves productivity by identifying performance thresholds and reorganizing data only when it benefit the application

Key differentiators

• Performs maintenance only on objects that require it 
• Maintains continuous access to DB2 during a reorganization
• Controls and increases collection of statistics without affecting applications accessing DB2
• Generates batch and online analysis reports to proactively manage space allocation
• Enables you to control database performance maintenance through a centralized, common interface
• Integrates with BMC SQL Performance for DB2 to identify objects that are experience both degraded statistics and degrading performance