Enabling CLI applications with pureQuery client optimization

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:
  • You must install IBM Optim pureQuery Runtime 2.1 or later.

    A CLI application that is enabled with pureQuery client optimization uses a license file that is contained in the pureQuery Runtime installation. pureQuery Runtime does not need to be installed on the same machine where the CLI application is running.

  • You must install at least one of the following products that support the call level interface (CLI) and pureQuery client optimization:
    • IBM Data Server Driver for ODBC and CLI, Version 9.7 Fix Pack 3 or later
    • IBM Data Server Runtime Client, Version 9.7 Fix Pack 3 or later
    • IBM Data Server Client, Version 9.7 Fix Pack 3 or later
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:

  1. Activate the pureQuery license file for the CLI application.
    • If you are using the IBM Data Server Driver for ODBC and CLI:
      1. Locate the correct version of the license file in the pureQuery installation directory. For example, C:\Program Files\IBM\purequery\license\clientv97\.
        Tip: You can use the DB2 db2level command provided in the driver package to determine the version of your driver package.
      2. Copy the license file dspq_rt.lic to the IBM Data Server Driver Package license directory.

        The license directory is the directory where the IBM Data Server Driver for ODBC and CLI, is installed. For example, C:\Program Files\IBM\IBM DATA SERVER DRIVER\license\.

    • If you are using another DB2 client or data server:

      In a command prompt, run the following command: db2licm -a C:\pqRuntime221\pureQuery\dspq_rt.lic where C:\pqRuntime221\ is the directory of your pureQuery Runtime installation.

  2. 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.


Feedback