Datasheet

6 Performance management and optimization solutions for IBM DB2 for Linux, UNIX and Windows
Optimize queries with InfoSphere Optim
Query Workload Tuner
Using InfoSphere Optim Query Workload Tuner, DBAs
can efciently and proactively optimize the performance of
SQL queries and query workloads by addressing problems
such as inaccurate statistics, inefciently designed SQL
statements, ineffective indexes and other factors. It includes
the following capabilities:
• Integrationwithdeveloperandperformancemanagement
toolssuch as IBM Data Studio allows developers to get query
tuning recommendations during development with just a
click. DBAs can also select a single query or query workload
from the performance monitor dashboard in InfoSphere
Optim Performance Manager or from the DB2 database itself
for further analysis.
• Advisorsthathelpboostapplicationperformance by
improving query design, statistics quality and index value.
• Built-inDB2queryandworkloadtuningexpertise helps
reduce specialized skill requirements.
• Complete-workloadanalysis helps manage costs by
tuning the entire application workload—thousands of SQL
statements—while balancing trade-offs between elements
such as statistics collection, CPU costs, index size and
statement regression for optimal overall performance.
Targeting query and query workload performance
improvements with InfoSphere Optim Query Workload
Tuner can directly impact your bottom line by helping
you increase customer satisfaction, avoid the costs of outages
and reduce development expenses.
Enable high performance for SAP applications
Building on the long history of IBM-SAP joint development
efforts, performance management solutions for IBM DB2
are optimized to work with DB2-SAP environments out of
the box. For example, InfoSphere Performance Manager
Extended Edition helps ensure a nondisruptive deployment
by following SAP guidelines to avoid disturbing SAP
configuration preferences. InfoSphere Optim Query Workload
Tuner helps improve application performance with expert
recommendations to enhance statistics collection, index
consolidation, and query and access plans. InfoSphere Optim
Configuration Manager helps DBAs explore data client and
server configurations and find database changes that might
relate to performance degradations.
For more information about performance management
benefits for SAP applications on DB2, visit ibm.co/aERwMw
“InfoSphere Optim Query Workload Tuner
for DB2 for Linux, UNIX and Windows
provides many features that reduce the
manual effort in performance analysis and
has roughly saved me two hours of query
tuning effort, increasing my productivity
by 40 percent.”
1
— Juvenal Garcia Cuevas, Consulting Manager, SBRT Computing