IBM InfoSphere Optim pureQuery Runtime D04QCLL-H User Manual
Product codes
D04QCLL-H
IBM Software
3
Together, IBM® InfoSphere® Optim™ Performance Manager,
IBM InfoSphere Optim Configuration Manager, IBM InfoSphere
Optim Query Workload Tuner and IBM InfoSphere Optim
pureQuery™ Runtime provide a powerful set of capabilities
to enhance database and application performance. IT staff can
use these solutions to quickly isolate performance problems
across the application, application server, network, database
server and operating system layers. Administrators can monitor
and drill down to the specific root cause of a performance
issue—such as resource shortages and exceptional conditions
in the database—before it reaches production systems.
IBM InfoSphere Optim Configuration Manager, IBM InfoSphere
Optim Query Workload Tuner and IBM InfoSphere Optim
pureQuery™ Runtime provide a powerful set of capabilities
to enhance database and application performance. IT staff can
use these solutions to quickly isolate performance problems
across the application, application server, network, database
server and operating system layers. Administrators can monitor
and drill down to the specific root cause of a performance
issue—such as resource shortages and exceptional conditions
in the database—before it reaches production systems.
Empower your team for true
end-to-end management
Performance management and optimization solutions for
DB2® cover the entire chain of events, from detection of a
performance issue through its analysis and resolution:
DB2® cover the entire chain of events, from detection of a
performance issue through its analysis and resolution:
•
Monitoring and diagnosis: DBAs can monitor database
environments, receive notification if a problem arises and
then pinpoint the source of the problem through InfoSphere
Optim Performance Manager. DBAs can also contextually
launch InfoSphere Optim Configuration Manager from
within InfoSphere Optim Performance Manager to find out
if a configuration change in the data environment might be
the cause of an emerging performance issue.
environments, receive notification if a problem arises and
then pinpoint the source of the problem through InfoSphere
Optim Performance Manager. DBAs can also contextually
launch InfoSphere Optim Configuration Manager from
within InfoSphere Optim Performance Manager to find out
if a configuration change in the data environment might be
the cause of an emerging performance issue.
•
Optimization: Once a performance issue is pinpointed, DBAs
can transfer a single query or an entire query workload with
a single click to InfoSphere Optim Query Workload Tuner
to receive expert, actionable recommendations for improving
queries, access plans, statistics, indexes and more.
can transfer a single query or an entire query workload with
a single click to InfoSphere Optim Query Workload Tuner
to receive expert, actionable recommendations for improving
queries, access plans, statistics, indexes and more.
•
Performance and security: DBAs can use InfoSphere
Optim pureQuery Runtime to enhance the performance
and security of an application without changing the
existing application code, and to help reduce the time
needed to go live with newly developed applications.
Optim pureQuery Runtime to enhance the performance
and security of an application without changing the
existing application code, and to help reduce the time
needed to go live with newly developed applications.
A powerful set of solutions for maximizing performance
Performance management and optimization solutions for
IBM DB2 include:
IBM DB2 include:
•
InfoSphere Optim Performance Manager:
A comprehensive,
proactive solution that provides real-time monitoring and
performance warehousing for DB2 and IBM InfoSphere
Warehouse for Linux, UNIX and Windows
performance warehousing for DB2 and IBM InfoSphere
Warehouse for Linux, UNIX and Windows
•
InfoSphere Optim Configuration Manager:
An innovative
solution offering centralized, effective and efficient
management of database and client configurations
management of database and client configurations
•
InfoSphere Optim Query Workload Tuner:
An intelligent
solution that delivers expert recommendations to maximize
application performance, helping reduce specialized skill
requirements and the total cost of ownership
application performance, helping reduce specialized skill
requirements and the total cost of ownership
•
InfoSphere Optim pureQuery Runtime:
This high-
performance data access platform helps enhance existing
in-house database client applications and speed the
development and deployment of new applications
in-house database client applications and speed the
development and deployment of new applications
“IBM InfoSphere Optim Configuration Manager is a great tool for exploiting both the Adaptive
Compression and Multi-Temperature Data Management features in DB2. I would definitely make
use of InfoSphere Optim Configuration Manager’s features to find contiguous space on disks for better
I/O performance and allocate the most efficient storage devices for the most demanded data.”
— Juvenal Garcia Cuevas, Consulting Manager, SBRT Computing