Use this roadmap as an overview for the tasks to migrate
from IBM® Optimization
Service Center to InfoSphere Optim™ Query
Workload Tuner for DB2 for z/OS®.
About this task
The migration from Optimization Service Center to InfoSphere Optim Query
Workload Tuner for DB2 for z/OS includes
installing InfoSphere Optim Query
Workload Tuner for DB2 for z/OS and
configuring your DB2® subsystems
for query tuning and query-workload tuning.
Procedure
To migrate from Optimization Service Center to InfoSphere Optim Query
Workload Tuner for DB2 for z/OS:
- If you want to reuse existing projects, export those projects
by following these steps in Optimization Service Center:
- Click .
- In the Export Project window, select
the project to export.
- Select the directory to contain the exported project.
- Click Finish.
The exported project is stored in a compressed file that
you can import later.
- Follow these steps to export individual workloads.
- Open the Workload List view.
- Right-click the workload to export and select Export.
- Specify the amount of information for the exported workload
to contain.
- In the File field, type the path
and name for the file to contain the workload. The extension must
be .zip. If you do not specify a path, Optimization Service Center
saves the file in the directory of the current project.
- Uninstall Optimization Service Center.
- On your Windows desktop,
click . The Optimization Service Center Uninstaller wizard
opens.
- Click Next, and click Uninstall.
The uninstallation process runs. When it completes, Optimization Service
Center is no longer installed on the workstation.
- Click OK.
The exported workload is stored in a compressed file that
you can import later.
- Follow either of these steps:
- If you plan to activate the license for IBM InfoSphere® Optim Query Workload Tuner on any DB2 databases or subsystems, you
can install IBM Data Studio
full client, Version 3.1.1 and the license activation kit through
the IBM Installation Manager
wizard or silently from a command-line.
- If you do not plan to activate the license for IBM InfoSphere Optim Query Workload Tuner on any DB2 databases or subsystems, you
can install only IBM Data Studio
full client, Version 3.1.1 through the IBM Installation
Manager wizard or silently from a command-line.
- Configure the DB2 for z/OS subsystem
for query tuning either from the client or by running a JCL job:
What to do next
To start tuning in the
Query Tuner Workflow Assistant:
- Open the IBM Data
Studio client.
- In the Data Source Explorer, open the connection to the subsystem.
- Expand the connection, so that the subsystem is visible.
- Right-click the subsystem and click .