IBM InfoSphere Optim pureQuery Runtime D04QBLL-E User Manual
Product codes
D04QBLL-E
2 Performance management and optimization solutions for IBM DB2 for Linux, UNIX and Windows
Poor application and database performance can have a signif-
icant effect on a company’s bottom line, such as lost sales and
customer churn for e-commerce sites, or for mission-critical
systems, substantially reduced productivity and revenue.
Missed service-level agreements (SLAs) may lead to loss of
customers, a damaged brand and even fines and other penalties.
icant effect on a company’s bottom line, such as lost sales and
customer churn for e-commerce sites, or for mission-critical
systems, substantially reduced productivity and revenue.
Missed service-level agreements (SLAs) may lead to loss of
customers, a damaged brand and even fines and other penalties.
Addressing application and database performance is a tough
challenge: organizations are under constant pressure to develop
and deploy new business applications while ensuring that
existing applications maintain optimal performance levels
to meet customer expectations. But as usage increases, appli-
cations often become less responsive. And with data volumes
doubling in size every five years, database performance can
become unacceptably sluggish.
challenge: organizations are under constant pressure to develop
and deploy new business applications while ensuring that
existing applications maintain optimal performance levels
to meet customer expectations. But as usage increases, appli-
cations often become less responsive. And with data volumes
doubling in size every five years, database performance can
become unacceptably sluggish.
Attempting to solve these problems by purchasing more
hardware and adding staff causes infrastructure and resource
hardware and adding staff causes infrastructure and resource
costs to skyrocket and is not a long-term solution. Database
administrators (DBAs) can spend significant amounts of time
responding to a performance problem—time that could be
spent on more strategic work to help the business reduce
operational costs and become more efficient.
administrators (DBAs) can spend significant amounts of time
responding to a performance problem—time that could be
spent on more strategic work to help the business reduce
operational costs and become more efficient.
Address performance challenges and
manage costs
IBM offers solutions that help you implement a best-
practice methodology to identify, diagnose, solve and prevent
performance problems while reducing the time and money
spent on performance-related tasks (see Figure 1).
practice methodology to identify, diagnose, solve and prevent
performance problems while reducing the time and money
spent on performance-related tasks (see Figure 1).
By combining solutions for integrated performance
management, DBAs can move out of reaction mode and
resolve performance issues before they affect the business.
management, DBAs can move out of reaction mode and
resolve performance issues before they affect the business.
• Receive early notifications
of problems before they
impact production.
impact production.
• Quickly isolate problems
across database, network
and application layers.
and application layers.
• Get visibility into problems
by workload to prioritize
response.
response.
Identify
• Follow guided workflows to
diagnose issues.
• Get complete views of data,
from real time to any time.
• Dig into the root causes of
problems with detailed
drill-down capabilities.
drill-down capabilities.
• Use built-in integration to
leverage data from other
IBM solutions.
IBM solutions.
• Spot changes that may be
related to performance
slowdowns.
slowdowns.
Diagnose
• Receive easy-to-understand,
actionable recommendations
for problem resolution.
for problem resolution.
• Tune entire workloads to
balance costs across query
and insert actions.
and insert actions.
• Minimize slowdowns that
impact user productivity
and revenue.
and revenue.
Solve
• Capture and analyze real-time
and historical data for capacity
planning and growth.
planning and growth.
• Proactively optimize the
performance of query
workloads, database and
applications.
workloads, database and
applications.
• Configure DB2 Workload
Manager to allocate resources
according to business priority.
according to business priority.
• Foster cross-team
collaboration to improve
security, performance and
manageability.
security, performance and
manageability.
Prevent
Figure 1
: The proactive IBM approach to performance management is designed to identify, diagnose, solve and prevent bottlenecks.