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