Use this roadmap as an overview for the tasks to migrate from IBM® Optimization Service Center to IBM InfoSphere Optim™ Query Tuner for DB2 for z/OS® or InfoSphere Optim Query Workload Tuner for DB2 for z/OS.
The migration from Optimization Service Center to InfoSphere Optim Query Tuner for DB2 for z/OS or InfoSphere Optim Query Workload Tuner for DB2 for z/OS includes installing InfoSphere Optim Query Tuner for DB2 for z/OS or InfoSphere Optim Query Workload Tuner for DB2 for z/OS and configuring a DB2 subsystem for the InfoSphere 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 InfoSphere 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 InfoSphere Optim Query Tuner for DB2 for z/OS or InfoSphere Optim Query Workload Tuner for DB2 for z/OS: