Roadmap for installing IBM InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows

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

Before you begin

About this task

The installation of InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows affects two locations: a DB2® database server and a client system. After the installation, configure the database to enable the facilities and objects that are required for tuning SQL statements.

Procedure

To install InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows:

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 InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows Version 3.1 is not activated on your database, run the installation program for server activation.
    • If the license 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 InfoSphere Optim Query Tuner client. The steps differ depending on whether the beta version is installed.
    Option Description
    A beta version is not installed Install the client.
    A beta version is installed
    1. Uninstall the beta version.
    2. Install the current version.
  3. After the client is installed, verify that the product license is activated.

What to do next

To start tuning query workloads:
  1. Open the InfoSphere Optim Query Tuner client.
  2. In the Data Source Explorer, connect to the database.
  3. Configure the database for query tuning.
  4. Right-click the connection and click Analyze and Tune > Start Tuning.

Feedback