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® 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
- Informix® Dynamic Server
v10.x, v11.10, v11.50, 11.70
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
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.