Skip to main content

DB2 database performance optimization feature

Information Management software

Save money. Reduce risk.

Upgrade today! Learn about the benefits of upgrading to the latest version of DB2

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.

0% financing for software

0% financing for software

A cushion for your bottom line