Integrating pureQuery Runtime with other InfoSphere Optim tools

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
pureQuery development environment with Data Studio and other InfoSphere Optim tools

For information about developing Java data access applications with Data Studio, see Overview of developing and optimizing Java(tm) data access applications.


Feedback