The migration from DB2 Optimization Expert for z/OS 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 DB2 Optimization Expert for z/OS, and then installing the Optim Query Tuner client. After the installation, configure the subsystem by migrating the EXPLAIN tables, Query Tuner tables, packages, and stored procedures that were created by DB2 Optimization Expert.
To migrate from DB2 Optimization Expert for z/OS 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.