Datasheet

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 nes 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 ve years, database performance can
become unacceptably sluggish.
Attempting to solve these problems by purchasing more
hardware and adding staff causes infrastructure and resource
costs to skyrocket and is not a long-term solution. Database
administrators (DBAs) can spend signicant 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 efcient.
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).
By combining solutions for integrated performance
management, DBAs can move out of reaction mode and
resolve performance issues before they affect the business.
•Receiveearlynotications
of
problemsbeforethey
impact production.
•Quickly
isolateproblems
acrossdatabase,network
and
applicationlayers.
•Get
visibilityintoproblems
by
workloadtoprioritize
response.
Identify
•Followguidedworkows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.
•Usebuilt-inintegrationto
leveragedatafromother
IBM solutions.
•Spotchangesthatmaybe
related to performance
slowdowns.
Diagnose
•Receiveeasy-to-understand,
actionable recommendations
for problem resolution.
•Tuneentireworkloadsto
balancecostsacrossquery
and insert actions.
•Minimize
slowdownsthat
impactuserproductivity
and
revenue.
Solve
•Captureandanalyzereal-time
andhistoricaldataforcapacity
planning and growth.
•Proactively
optimizethe
performanceofquery
workloads,databaseand
applications.
•Congure
DB2Workload
Manager to allocate resources
according
tobusinesspriority.
•Foster
cross-team
collaborationtoimprove
security,performanceand
manageability.
Prevent
Figure 1: The proactive IBM approach to performance management is designed to identify, diagnose, solve and prevent bottlenecks.