DB2 database performance

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. When you couple load balancing and multi-temperate data management together, you can achieve better utilization of existing hardware, optimize storage device allocation, which can help boost performance and reduce cost.

DB2 Workload Manager is now integrated with DB2 pureScale and includes a powerful time-based control mechanism that can be quickly configured and deployed to automatically throttle low priority workloads. Additionally, the use of bufferpool I/O prioritization and integration with Linux workload management, give you even more control over the DB2 execution environment.

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.