Roadmap for installing IBM InfoSphere Optim Query Workload Tuner for DB2 for z/OS

Use this roadmap as an overview for the tasks to install IBM® InfoSphere Optim™ Query Workload Tuner for DB2 for z/OS®.

Before you begin

About this task

The installation of InfoSphere Optim Query Workload Tuner for DB2 for z/OS affects two locations: a DB2 subsystem and a client system. After the installation, configure the subsystem to enable the facilities and objects that are required for tuning SQL statements.

Procedure

To install InfoSphere Optim Query Workload Tuner for DB2 for z/OS:

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

  1. On each subsystem, activate the product license:
    • If the license is not activated on your subsystem, follow these steps:
      1. Refer to the program directory for InfoSphere Optim Query Tuner for DB2 for z/OS and perform the SMP/E tape installation. See Install the license file and the configuration files on the subsystem.
      2. Refer to the program directory for InfoSphere Optim Query Workload Tuner for DB2 for z/OS and perform the SMP/E tape installation. See Install the license file and the configuration files on the subsystem.
      3. Activate the product license for the current version.
    • If the license is activated on your subsystem, you do not need to activate the current license again.

      If you want to configure the subsystem by using the InfoSphere Optim Query Tuner client or by running a JCL job that you upload from the client to the subsystem, you do not need to perform the SMP/E tape installation. If you do not want to use either of these methods, perform the SMP/E tape installation. See Install the configuration files on a subsystem.

      Note: Before you perform the SMP/E tape installation for InfoSphere Optim Query Workload Tuner for DB2 for z/OS, you need to refer to the program directory for InfoSphere Optim Query Tuner for DB2 for z/OS and do the installation for InfoSphere Optim Query Tuner for DB2 for z/OS.
  2. On the client system, install the current version of the InfoSphere 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. Uninstall the beta version.
    2. Install the current version.
    A previous version is installed
    1. Uninstall the previous 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 subsystem.
  3. Configure the DB2 for z/OS subsystem for query tuning either from the client or the server:
  4. Right-click the connection and click Analyze and Tune > Start Tuning.

Feedback