Roadmap for migrating from IBM Optimization Service Center to IBM Optim Query Tuner for DB2 for z/OS or Optim Query Workload Tuner for DB2 for z/OS

Use this roadmap as an overview for the tasks to migrate from IBM® Optimization Service Center to IBM Optim™ Query Tuner for DB2® for z/OS® or Optim Query Workload Tuner for DB2 for z/OS.

Before you begin

About this task

The migration from Optimization Service Center to Optim Query Tuner for DB2 for z/OS or Optim Query Workload Tuner for DB2 for z/OS includes installing Optim Query Tuner for DB2 for z/OS or Optim Query Workload Tuner for DB2 for z/OS and configuring a DB2 subsystem for the Optim Query Tuner client.

The installation affects two locations, a DB2 subsystem and a client system. On the subsystem, you need to perform the SMP/E tape installation to extract the license file and the files for configuration, and then activate the license. On the client system, you need to migrate the client by uninstalling Optimization Service Center, and then installing the Optim Query Tuner client. After the installation, configure the subsystem to migrate the EXPLAIN tables, Query Tuner tables, packages, and stored procedures that were created by Optimization Service Center.

Procedure

To migrate from Optimization Service Center to Optim Query Tuner for DB2 for z/OS or Optim Query Workload Tuner for DB2 for z/OS:

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

  1. On the subsystem, activate the product license:
    1. Perform the SMP/E tape installation for Optim Query Tuner for DB2 for z/OS or Optim Query Workload Tuner for DB2 for z/OS. See Install the license file and the configuration files on the subsystem.
      Note: Before you perform the SMP/E tape installation for Optim Query Workload Tuner for DB2 for z/OS, you need to refer to the program directory for Optim Query Tuner for DB2 for z/OS and do the tape installation for Optim Query Tuner for DB2 for z/OS.
    2. Activate the product license for Optim Query Tuner for DB2 for z/OS or Optim Query Workload Tuner for DB2 for z/OS.
  2. On the client system, install the current version of the Optim Query Tuner client:
    1. Optional: Export the projects from Optimization Service Center.
    2. Uninstall Optimization Service Center.
    3. Install the client for Optim Query Tuner for DB2 for z/OS or Optim Query Workload Tuner for DB2 for z/OS.
  3. After the client is installed, verify the product license.
  4. Configure the DB2 for z/OS subsystem for query tuning either from the client or the server:
  5. If you have data from Optimization Service Center, import the data. See Importing projects, SQL categories, filters, database connection profiles, and workloads.

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 subsystem.
  3. Right-click the connection and click Start Tuning.

For help in the workflow assistant, click the help button Help 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