These documents provide a general overview of InfoSphere® Optim® pureQuery Runtime.

• pureQuery platform technical overview and FAQs on IBM.com This page describes the value and components of pureQuery software, describes the offerings in the InfoSphere Optim portfolio where pureQuery technology is available, and includes frequently asked questions about the technology.

• InfoSphere Optim pureQuery Runtime for Linux®, UNIX® and Windows® on IBM.com This page provides more links to more resources, including product documentation, demos, and related products.

• InfoSphere Optim pureQuery Runtime for z/OS® on IBM.com This page provides links to more resources, including product documentation, demos, and related products.

• IBM Data Studio From this page, you can download a trial version of Data Studio. InfoSphere Optim pureQuery Runtime is packaged at no extra charge for development use with Data Studio full client Version 3.1. To use pureQuery in a production environment, you must purchase an InfoSphere Optim pureQuery Runtime license.

• InfoSphere Optim pureQuery Runtime information center This information center contains the documentation for pureQuery Runtime.

Back to top

This document contains pureQuery performance information.

• IBM Optim pureQuery Runtime for z/OS performance This article provides a brief overview of the pureQuery platform, a summary of enhancements introduced since this article was first published, and the results of a performance study comparing pureQuery access methods with various popular Java™ data access alternatives (including JDBC). While the study was performed with a previous release of pureQuery Runtime, the general performance conclusions are valid for the current release.

Back to top

This scenario describes how pureQuery is used with other InfoSphere Optim solution products.

• Optim Performance Management Solution (15 minutes) This on-demand video describes how the InfoSphere Optim pureQuery data access platform is used with Optim Performance Manager and InfoSphere Optim Query Tuner to detect and correct an emergent database problem, accelerate performance and stability of an existing application, and build performance into a new application.

Back to top

These documents provide information about how to install InfoSphere Optim pureQuery Runtime.

• System requirements for InfoSphere Optim pureQuery Runtime This document describes the minimum system requirements to install InfoSphere Optim pureQuery Runtime.

• InfoSphere Optim pureQuery Runtime Quick Start Guide This guide gets you started with a typical installation for InfoSphere Optim pureQuery Runtime for Linux, UNIX, and Windows Version 3.1.

• Installing InfoSphere Optim pureQuery Runtime These topics describe how to install InfoSphere Optim pureQuery Runtime for Linux, UNIX, and Windows and InfoSphere Optim pureQuery Runtime for z/OS.

Back to top

Use these documents to learn how to best use pureQuery Runtime to simplify and enhance the performance of your data access applications.

• Getting Started with pureQuery (e-book) In this free book, learn what pureQuery is and how to use Data Studio to create Java database applications with the pureQuery API. You also learn how to use pureQuery to optimize existing Java database applications and Java Persistence API (JPA) and Hibernate applications. You can download a sample Java application that is used in the book.

• Write high performance, Java data access applications, Part 1: Introducing pureQuery annotated method data access objects This article explains why a developer might choose to write a pureQuery data access object with data access object (DAO) interfaces and annotated methods. The article discusses some of the differences between using pureQuery annotated methods and pureQuery built-in inline methods, and gives a brief overview of the most powerful features of pureQuery annotated methods.

• Write high performance Java data access applications, Part 2: Introducing pureQuery built-in inline methods This article explains the key features of inline methods and why a developer might choose to use them. For example, with inline methods, SQL or XQuery statements can be created inline within the code as a Java string object and passed as a string parameter to the pureQuery Data interface method.

• Write high performance Java data access applications, Part 3: pureQuery API best practices This article summarizes some best practices for pureQuery development and provides real-world scenarios that illustrate how to implement these practices.

• Developing a Java application that uses pureQuery annotated methods This tutorial introduces some of the features in Data Studio that you can use to develop an application that uses pureQuery annotated methods with data access object (DAO) interfaces.

• Using the IBM Integration Module for Hibernate and pureQuery This article describes using InfoSphere Optim pureQuery Runtime and the IBM Integration Module with Hibernate applications. pureQuery Runtime and the IBM Integration Module simplify the process of generating DB2® static SQL for Hibernate applications. pureQuery Runtime also enables Hibernate applications that access DB2 or Informix data sources to benefit from the pureQuery heterogeneous batching feature. This article includes a downloadable sample application.

• Auto-tuning Hibernate applications with pureQuery Runtime This article describes auto-tuning Hibernate applications with InfoSphere Optim pureQuery Runtime. Auto-tuning for Hibernate automates the most common problems faced by users of Hibernate, which is to optimize the database access patterns of Hibernate in each use case of the application without manual intervention.

• Using the IBM Integration Module for iBATIS and pureQuery This article describes combining InfoSphere Optim pureQuery Runtime and the IBM Integration Module with iBATIS applications. pureQuery Runtime and the IBM Integration Module simplify the process of generating DB2 static SQL for iBATIS applications. pureQuery Runtime also enables iBATIS applications that access DB2 or Informix to benefit from the pureQuery heterogeneous batching feature. This article includes a downloadable sample application.

Back to top

These documents provide information about how to enable pureQuery client optimization.

• Getting Started with pureQuery (e-book) In this free e-book, learn what pureQuery is and how to use Data Studio to create Java database applications with the pureQuery APIs. You also learn how to use pureQuery to optimize existing Java database applications and Java Persistence API (JPA) and Hibernate applications. You can download a sample Java application that is used in the book.

• Enable a Java application with pureQuery client optimization In these topics, learn how to configure pureQuery Runtime to capture SQL statements from a Java application. You also learn how to configure pureQuery Runtime to control SQL statements that are run by an application and bind SQL statements to a DB2 database.

• Automate pureQuery client optimization with WebSphere applications Learn how to automate the pureQuery client optimization process with Apache Ant script technologies.

• Deploying pureQuery client optimization applications These information center topics contain information about the benefits of using pureQuery client optimization, the steps you follow to deploy pureQuery client optimization, example scenarios, and guidance information.

Back to top

These documents provide information about how to configure InfoSphere Optim pureQuery Runtime.

• Deploying pureQuery client optimization applications These topics describe configuring pureQuery Runtime client optimization in a simple environment, and with WebSphere Application Server. The topics also provide guidelines and recommendations for pureQuery client optimization.

• Set up an SQL management repository for pureQuery Runtime using an Ant script In this developerWorks article, learn how to create and manage a repository with an Apache Ant script. You also learn how to run the Ant script from within Data Studio.

Back to top

The resources in this section provide information about identifying and solving problems.

• IBM Data Studio and pureQuery Runtime forum This community forum provides a place to discuss topics of interest to users of Data Studio and pureQuery Runtime for new development or client optimization.

• InfoSphere Optim pureQuery for Linux, UNIX, and Windows support page The main support page for InfoSphere Optim pureQuery Runtime for Linux, UNIX, and Windows on IBM.com. This customizable page contains links to support resources, downloads, and documentation.

• InfoSphere Optim pureQuery for z/OS support page The main support page for InfoSphere Optim pureQuery Runtime for z/OS on IBM.com. This customizable page contains links to support resources, downloads, and documentation.

• List of known issues and workarounds for InfoSphere Optim pureQuery for z/OS from the IBM support knowledge base This link opens a customized query for known problems and workarounds. When problems are discovered and resolved, the knowledge base is updated and maintained with new information. You can refine the query or create a different query.

Back to top