InfoSphere® Optim™ pureQuery™ Runtime works
with IBM® Data
Studio, InfoSphere Optim Performance Manager, and InfoSphere Optim Query Workload Tuner. With
these tools, you can develop data access applications, and isolate
and resolve issues with data access applications.
Components
of the integrated solution
pureQuery Runtime
components
The following are the components for data access application
development, monitoring, and problem resolution:
- InfoSphere Optim pureQuery Runtime
- Provides flexible deployment of static SQL for DB2® databases
- Provides a simple and intuitive API for Java™ applications
- Provides utilities that manage SQL statements and repositories
- IBM Data
Studio
- Provides an integrated development environment with Java and SQL support
- Improves problem isolation and impact analysis
- Manages SQL Management repositories
- InfoSphere Optim Query Workload Tuner
- Analyzes and tunes SQL query workloads and single SQL queries.
- Extended Insight technology in InfoSphere Optim Performance Manager and Omegamon
XE
- Analyzes transaction response time across the various layers that
have an impact on data access operations. Transaction response can
be can be analyzed for the application server, data server driver,
network, and database server. Extended Insight technology works with Optim Performance Manager on DB2 for Linux, UNIX,
and Windows databases and
Omegamon XE on DB2 z/OS® systems.
Integration
summary
When you develop and troubleshoot data access applications,
you can run InfoSphere Optim Query Workload Tuner Tuner
from Data Studio to
optimize queries. From Data Studio, you can
also retrieve database performance information that is gathered by InfoSphere Optim Performance Manager Extended
Insight and stored in an Optim Performance
Manager repository.
Figure 1. InfoSphere Optim tools that can
be used to develop data access applications
For information about developing Java data access applications with Data Studio, see Overview of developing and optimizing Java(tm) data access
applications.