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.
- 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.
The exported workload 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 full client, Version 3.1.1:
- If you plan to activate the license for IBM InfoSphere® Optim Query Workload Tuner on any DB2 databases or subsystems, install IBM Data Studio full client, Version
3.1.1 together with 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, 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.
- 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 .