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.
- 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.
- Install IBM
Data Studio client, Version 3.2.
- Configure your DB2 for z/OS subsystem for tuning with
InfoSphere Optim Query Workload Tuner.
What to do next
To start tuning in the Query Tuner Workflow Assistant:
- Open the IBM Data
Studio client.
- Import your projects.
- Select .
- In the Import wizard, expand Query
Tuner and select Projects.
- Click Next and use the next page of the
wizard to browse to the location of your projects and import them.
- 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 .