Features and benefits
Optim Performance Manager Extended Edition for DB2 for Linux, UNIX and Windows provides a comprehensive and proactive performance management solution for database applications. A follow-on to DB2 Performance Expert, Optim Performance Manager Extended Edition helps optimize the performance and availability of DB2 and DB2 applications with a proactive, end to end performance management approach. Use Optim Performance Manager Extended Edition to identify, diagnose, solve and prevent performance problems before they impact the business. These capabilities are also available on DB2 for z/OS through Tivoli OMEGAMON XE for DB2 Performance Expert. Use Optim Performance Manager Extended Edition for DB2 for Linux, UNIX, and Windows to:
Identify and Diagnose Performance Problems
Monitor and analyze multiple DB2 instances - including single partition, multi- partition and pureScale databases - running a wide variety of workloads, all from a single control point. Get up and monitoring quickly with predefined, customizable monitoring templates for OLTP, business intelligence, SAP, and enterprise content management.
Monitor database end to end response time for Java and DB2 CLI database applications with out of the box workload definitions for WebSphere, SAP, WebSphere Application Server, Cognos, InfoSphere DataStage, and InfoSphere SQL Warehouse. Optim Performance Manager Extended Edition extends database monitoring across the database client, the application server, and the network, giving DBAs immediate insight into where database workloads, transactions, and SQL requests are spending their time. This allows organizations to:
Improve availability of mission critical database applications. Detect negative trends sooner including: eroding response times for database APIs; network congestion between the application and the database; or other factors key to sustaining service level agreements.
Manage applications to meet service level agreements more easily and effectively. Now DBAs can see the response time for single SQL requests or complete database transactions from the applications point of view, enabling creation of performance indicators that more directly relate to the user's experience.
Reduce the time needed to isolate performance issues from days down to minutes. Use graphical displays to see where workloads, transactions, and SQL requests originate in the application, and how the time spent is spread across the database client, the application server, the database server, and the network between them. Filter by application, database, user, or other criteria.
Improve collaboration and resolution of performance problems across the software stack by providing additional performance indicators such as connection pool wait times and other vital database-related performance statistics
Optim Performance Manager Extended Edition delivers a browser based dashboard approach to help users quickly identify potential problems. The new browser based interface includes performance overview displays with associated health indicators to quickly detect problems in the overall environment and within a specific database. Intelligent diagnostic dashboards provide relevant metrics that focus in on a particular problem area and provide the details needed to determine root cause including:
Locking conflicts, deadlocks and timeouts
Long running or untuned SQL statements
Sorting or prefetching issues
Buffer pool, cache, and heap sizes
Operating system memory or CPU shortages
Partition skews or overloaded partitions
Log performance issues
Alert administrators by email or page when events occur to find and fix problems before they affect the business. Users can customize alerts and configuration options such as type, severity, frequency, back-outs as required. Users can also create customized reports. This means users can decide which diagnostic information is most important and create meaningful customized reports to improve efficiency.
Prevent Performance Problems
Analysis of real time data to see what is actively happening or leverage historical data for analysis and reporting, trend analysis, and growth planning is available.
Manage Workloads. Optim Performance Manager includes DB2 Workload Manager(WLM) tooling to:
Define workloads
Enable aging
Assign business priorities to workloads to ensure Service Level Agreements
Monitor service classes, workloads, and work classes
Obtain sophisticated usage statistics and definitions
View real-time data and historical data
Understand workload at a point in time
Understand workload patterns and long-term development issues
Derive effective service classes and thresholds
Perform workload analysis for workload profiling and accounting.
Solve Performance Problems
Integration with Tivoli Composite Application Manager provides a comprehensive, consolidated view across the enterprise to guide IT Professionals through problem isolation, analysis and resolution. This integration drives efficiencies and collaboration between applications, system and database IT staff.
Integration with the Optim family enables users to close the loop on performance problem resolution and foster collaboration.
Integration with Optim Query Tuner passes problematic SQL statements directly into a query tuning session so that the query can be analyzed, tuned, and re-deployed into production.
Integration with Optim pureQuery Runtime enables instant isolation of the SQL statement application source code and facilitates collaboration between the database administrator (DBA) and the developer to resolve the problem. Optim pureQuery Runtime also allows for optimizing the SQL without altering the application
