The optional DB2 Performance Optimization feature gives you the insight and ability to optimize workload execution. This feature can save you money and lower your risks by helping you to do more work with your existing hardware, ensure Service Level Agreements (SLAs) are met or exceeded and increase DBA productivity.
The Performance Optimization Feature includes three capabilities: DB2 Workload Manager, InfoSphere Optim Performance Manager Extended Edition for DB2 for Linux, UNIX and Windows, and DB2 Query Patroller.
DB2 Workload Manager
DB2 Workload Manager gives you low overhead, fine grained control over the DB2 execution environment, including CPU and prefetch priority assigned to a particular workload, as well as the ability to execute workloads according to different business priorities. Use this control to reduce the risk of SLA failure by prioritizing execution of business critical workloads. At the same time, use this control to save money by throttling low priority work until it can execute without impacting the high priority work. Load balancing results in better utilization of existing hardware, which can help you delay your next server upgrade.
DB2 Workload Manager enhancements include a powerful new time-based control mechanism that can be quickly configured and deployed to automatically throttle low priority workloads. Other additions include bufferpool I/O prioritization and integration with Linux workload management, all of which give you even more control over the DB2 execution environment.
InfoSphere Optim Performance Manager Extended Edition for DB2 for Linux, UNIX and Windows
Performance optimization is a highly complex process with many interdependent factors requiring deep skills. These skills are often hard to come by and typically very expensive. Problem isolation can take days and require many people across different domains and expertise. Add to this, the pressure on business today and the constant state of flux – hardware upgrades, software upgrades, application enhancements, new application deployment.
InfoSphere Optim Performance Manager Extended Edition for DB2 for Linux, UNIX and Windows helps optimize the performance and availability of mission critical databases and applications. This solution enables organizations to resolve performance bottlenecks before they affect the business. Optim Performance Manager Extended Edition delivers a proactive, comprehensive performance management approach that allows IT staff to identify, diagnose, solve and prevent performance problems in DB2 and in associated applications including Java™ and DB2 Call Level Interface (CLI) applications, with out-of-the-box configurations for SAP, WebSphere, Cognos, InfoSphere DataStage, and InfoSphere Warehouse SQL Warehousing Tool applications.
DB2 Query Patroller
Tried-n-true technology, DB2 Query Patroller proactively and dynamically controls the flow of queries against the database. DB2 Query Patroller was the predecessor of DB2 Workload Manager but continues to be fully supported.
