Overview

The Database Performance for DB2 solution introduces "detect and correct" automation driven from a common console. The unique combination of innovative automation and exclusive, proven BMC Software technology delivers a full, flexible solution that keeps DBAs in the driver’s seat on achieving peak database performance. Corporate IT organizations with ever-increasing demands on their systems can rely on this solution to effectively manage the health of their critical databases, hold down costs, and to leverage and empower in-house staff.

Key Features

• Provides for the complete collection, storage and management of DB2 object statistics
• Automates management of DB2 objects through exception analysis of statistics allowing for reorganization on an as need basis
• Reorganizes DB2 databases without taking an application outage by using the BMC patented Snapshot Upgrade Feature
• Enables customization of automated statistics analysis to identify the specific objects that require maintenance
• Provides more efficient and accurate control of maintenance processing
• Enables comprehensive statistical collection without impacting application performance and superior monitoring of database performance
• Provides object groups for greater filtering control
• Updates DB2 history tables, DB2 catalog tables, and realtime statistics

Key Benefits

• Delivers integration with the BMC Software SmartDBA family of products via a common interface
• Provides sophisticated automation of problem detection and correction to sustain and maximize database performance
• Reduces workload through optimized utility job management
• Expands control over managing exception conditions with user-defined triggers, predefined system wide triggers and actions
• Enables proactive trend analysis and capacity planning
• Perform maintenance on only the objects that need it

Case Study

• SKH