After you install pureQuery Runtime,
you can enable a call level interface (CLI) application with client
optimization.
You obtain pureQuery features such as client
optimization by purchasing the IBM® InfoSphere™ Optim™ pureQuery Runtime product.
Before you begin
Before you enable a CLI application with pureQuery client
optimization:
Your CLI application can connect to the following databases
as data sources:
- DB2® for Linux, UNIX,
and Windows, Version 9 or
later
- DB2 Universal Database™ for z/OS® Version
8.1
- DB2 9.1 for z/OS
- DB2 10 for z/OS
- Informix® Dynamic Server
v10.x, v11.10, v11.50, 11.70
For the latest information about supported products and
database support for CLI application enabled with client optimization,
see System requirements for InfoSphere Optim pureQuery
Runtime.
If you intend to run SQL statements
statically, you run the Java-based pureQuery utilities Configure and
StaticBinder. On the computer where you run the utilities, you must
install and enable pureQuery Runtime. You must also have the following
products installed on the computer:
- Java Runtime Environment
(JRE) Version 1.5 or later
- IBM Data Server Driver for
JDBC and SQLJ Version 3.57 or 4.7.xx
The pureQuery Runtime JAR files, pdq.jar and pdqmgmt.jar, and
the Data Server Driver JAR files must be listed in the CLASSPATH on
the computer where you run the utilities.
Procedure
To enable CLI applications with pureQuery client optimization:
- Activate the pureQuery license file for the CLI application.
- Required for Microsoft Windows Vista operating systems: To
complete the activation of the pureQuery license file, run your application
and capture SQL data under an administrator account.
After
your application successfully captures SQL data by using an administrator
account, CLI client optimization features are enabled for users on
the system
You must perform this step once. If you try to use
CLI client optimization without taking this step, the application
will not be able to find a valid license key and returns an error.
Results
The pureQuery license file is activated for your drivers.
Your CLI applications can now use the pureQuery client optimization
capabilities.
What to do next
After activating the pureQuery license file, you can configure
your CLI application to enable pureQuery client optimization capabilities.
To
configure your application with pureQuery Runtime, you set pureQuery
Runtime keywords in your CLI application configuration file. pureQuery
Runtime checks for a valid pureQuery license if any pureQuery Runtime
keywords are specified in a configuration file. If a valid pureQuery
license is not found, pureQuery Runtime ends and returns the error
code SQL8029N.