After you install pureQuery® Runtime, you can enable a call
level interface (CLI) application or a .NET 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 or .NET application with pureQuery client optimization:
Your CLI or .NET 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 requirements,
supported products and database support for CLI and .NET 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 or .NET applications with pureQuery client optimization:
- Activate the pureQuery license
file for the application.
- Required for Microsoft Windows Vista or Windows 7 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, pureQuery client optimization features
are enabled for users on the system
You must perform this step
once. If you try to use pureQuery 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 or .NET applications
can now use the pureQuery client
optimization capabilities.
What to do next
After activating the pureQuery license
file, you can configure your CLI or .NET 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.