Activating the product license for InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows on a database

Before you can configure a DB2® for Linux, UNIX, and Windows database for query tuning from the client and use the advanced query-tuning features of InfoSphere Optim™ Query Workload Tuner for DB2 for Linux, UNIX, and Windows, you must activate the product license.

Before you begin

Important: If you are using DB2 for Linux, UNIX, and Windows Version 9.7 Fix Pack 1, Fix Pack 2, Fix Pack 3, or Fix Pack 4, you must run the db2updv97 command from a DB2 command line, if you have not already done so. For information about this command, see http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.admin.cmd.doc/doc/ r0054449.html.

In your DB2 for Linux, UNIX, and Windows database, ensure that the DB2_USE_DB2JCCT2_JROUTINE environment variable is set to YES and the KEEPFENCED configuration parameter is set to YES. For information about the DB2_USE_DB2JCCT2_JROUTINE environment variable, see Specification of a driver for Java routines. For information about the KEEPFENCED configuration parameter, see Keep fenced process configuration parameter.

About this task

If you do not activate the license for your product, you can access only the no-charge features. For a list of features, see Features by product.

Procedure

To activate the product license:

  1. Load the IBM® InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows V3.1.0.0 Server Configuration Kit on the machine where the database server is running.
  2. Run the installation program. Use one of the these options.
    Option Description
    Use the installation wizard
    1. Open the directory with the name that indicates your platform.
    2. Run the following command to open the wizard:
      • On Windows: install.exe
      • On Linux or UNIX: ./install.bin
    3. Follow the instructions in the wizard to complete the steps.
    4. Click Done to close the wizard.
    Use the console mode
    1. In a command line, navigate to the directory with the name that indicates your platform.
    2. Run the following command:
      • On Windows: install.exe -i console
      • On Linux or UNIX: ./install.bin -i console
    3. Follow the instructions in the console to complete the process.
    4. Press Enter to exit the console panel.
    Use silent installation
    1. Open the directory with the name that indicates your platform.
    2. Copy the OQWTLUWS.RSP file, which is the sample response file, from the server activation disk to the database server.
    3. Modify the OQWTLUWS.RSP file for your environment.
    4. In a command line, navigate to the directory that indicates your platform, and then run the following command:
      • On Windows: install.exe -i silent -f response_file_path_and_name
      • On Linux or UNIX: ./install.bin -i silent -f response_file_path_and_name
    5. When the installation is finished, verify that it is successful by checking the OQWTinstall_details_system_date.log or OQWTinstall_summary_system_date.log file. By default, the files are located in the logs subdirectory of your installation directory.

Results

The IBM InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows product license is activated.

The server-side files, including the uninstaller, are stored in the installation directory that you specified. On Windows, the default installation directory is C:\Program Files\IBM\OQWTS. On Linux, the default installation directory is /opt/IBM/OQWTS.

What to do next