DB2 9 for Linux UNIX and Windows

The DB2 Performance Optimization Feature provides advanced capabilities for managing workloads and optimizing performance across your database environment. It includes DB2 Workload Management, DB2 Performance Expert and DB2 Query Patroller.

DB2 Workload Management customizes your data server to support a spectrum of users and workloads on the same system, using either a predictive or reactive model. DB2 Performance Expert is a performance analysis and tuning tool for managing a heterogeneous mix of DB2 systems with a single end-user interface. DB2 Query Patroller is a powerful query workload management tool that controls submission and execution of queries to better manage DB2 data server workloads to meet business needs

Benefits

• Manages workloads across a database based on user and application priorities combined with resource availability and workload thresholds
• Allows you to define separate query classes to share system resources among all queries
• Automatically puts large queries on hold so that they can be canceled or scheduled to run during off peak hours
• Allows administrators to prioritize queued queries based on business needs
• Automatically manages the alerts that monitor a landscape of DB2 instances
• Provides current, recent history and historical data for automated analysis
• Provides hundreds of built-in reports that cover all aspects of DB2 operations
• Identifies resource shortages and exceptional conditions in DB2, both for current conditions and past history

DB2 Workload Management delivers new monitoring and historical information on workload activity, that can be used to better monitor user or application related database activity and to help DBA's report performance issues.

DB2 Performance Expert combines performance monitoring, reporting and buffer pool analysis into one tool that provides a single system overview that monitors all subsystems & instances across many different platforms.

DB2 Query Patroller proactively and dynamically controls the flow of queries against DB2 databases.