Migrating from IBM Optimization Service Center to InfoSphere Optim Query Workload Tuner for DB2 for z/OS

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®.

Before you begin

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:

  1. If you want to reuse existing projects, export those projects by following these steps in Optimization Service Center:
    1. Click Project > Export.
    2. In the Export Project window, select the project to export.
    3. Select the directory to contain the exported project.
    4. Click Finish.
    The exported project is stored in a compressed file that you can import later.
  2. Export individual workloads.
    1. Open the Workload List view.
    2. Right-click the workload to export and select Export.
    3. Specify the amount of information for the exported workload to contain.
    4. 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.
  3. Uninstall Optimization Service Center.
    1. On your Windows desktop, click Start > Programs > IBM Optimization Service Center for DB2 for z/OS > Uninstall Optimization Service Center. The Optimization Service Center Uninstaller wizard opens.
    2. Click Next, and click Uninstall. The uninstallation process runs. When it completes, Optimization Service Center is no longer installed on the workstation.
    3. Click OK.
  4. Install IBM Data Studio full client, Version 3.1.1:
  5. 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:
  1. Open the IBM Data Studio client.
  2. Import your projects.
    1. Select File > Import.
    2. In the Import wizard, expand Query Tuner and select Projects.
    3. Click Next and use the next page of the wizard to browse to the location of your projects and import them.
  3. In the Data Source Explorer, open the connection to the subsystem.
  4. Expand the connection, so that the subsystem is visible.
  5. Right-click the subsystem and click Start Tuning.

Feedback