Activating the product license and enabling the Index Advisor stored procedure for Optim Query 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 IBM® Optim™ Query Tuner for DB2 for Linux, UNIX, and Windows, you must activate the product license and enable the Index Advisor stored procedure on the database.

About this task

You can run an installation program on a database to activate the license and enable the Index Advisor stored procedure. You can use the installation wizard or the console mode. Optionally, you can use a response file to install silently.

If you do not activate the license for your product, you can access only the Data Studio IDE and Data Studio stand-alone features. For a list of features, see Single-query tuning features by product.

Procedure

To activate the product license and enable the Index Advisor stored procedure:

  1. Insert the server activation DVD for IBM Optim Query Tuner for DB2 for Linux, UNIX, and Windows Version 2.2.1 into the DVD drive of the database server.
  2. Run the installation program. Use one of the following 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 OQTLUWS.RSP file, which is the sample response file, from the DVD to the database server.
    3. Modify the OQTLUWS.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 OQTinstall_details_system_date.log or OQTinstall_summary_system_date.log file, which is in the following default directory:
      • On Windows: C:\Documents and Settings\user_name\oqt\logs
      • On Linux or UNIX: home_directory/oqt/logs

Feedback