Roadmap for installing IBM Optim Query Tuner for DB2 for Linux, UNIX, and Windows and configuring a DB2 database for query tuning

Use this roadmap as an overview for the tasks to install IBM® Optim™ Query Tuner for DB2® for Linux, UNIX, and Windows and to configure a DB2 for Linux, UNIX, and Windows database for the Optim Query Tuner client.

Before you begin

About this task

The installation of Optim Query Tuner for DB2 for Linux, UNIX, and Windows affects two locations, a DB2 database server and a client system. On the database, you need to run an installation program to activate the product license and enable the Index Advisor stored procedure. On the client system, you need to install the Optim Query Tuner client. After the installation, configure the database to enable the facilities and objects for the client.

Procedure

To install Optim Query Tuner for DB2 for Linux, UNIX, and Windows and configure databases for query tuning:

Note: Steps 1 and 2 can be done in any order or concurrently.

  1. On each database server, activate the product license:
    • If the license for Optim Query Tuner for DB2 for Linux, UNIX, and Windows Version 2.2 is not activated on your database, run the installation program for server activation. See Activating the product license and enabling the Index Advisor stored procedure.
    • If the license for Optim Query Tuner for DB2 for Linux, UNIX, and Windows Version 2.2 is activated on your database, you do not need to activate the current license again.
  2. On the client system, install the current version of the Optim Query Tuner client. The steps differ depending on whether a previous version or a beta version is installed.
    Option Description
    Neither a previous version nor a beta version is installed Install the client.
    A beta version is installed
    1. Optional: Export your existing user data from the beta version. See Exporting projects, SQL categories, filters, and database connection profiles from the Optim Query Tuner client.
    2. Uninstall the beta version.
    3. Install the current version.
    A previous version is installed
    1. Optional: Export your existing user data from the previous version. See Exporting projects, SQL categories, filters, and database connection profiles from the Optim Query Tuner client.
    2. Upgrade the client to the current version.
  3. After the client is installed, verify the product license.
  4. Configure each DB2 for Linux, UNIX, and Windows database for query tuning.
  5. If you have data from a previous version or a beta version, import the data. See Importing projects, SQL categories, filters, and database connection profiles.

What to do next

To start tuning in the workflow assistant for query tuning:
  1. Open the Optim Query Tuner client.
  2. In the Data Source Explorer, connect to the database.
  3. Right-click the connection and click Start Tuning.

For help in the workflow assistant, click the help button Help Icon at the top of each page and in each window that you open.

For an introduction to the workflow assistant for query tuning, see Workflow assistant for query tuning.


Feedback