Migrating from the InfoSphere Optim Query Tuner client to the IBM Data Studio full client, Version 3.1.1

The InfoSphere® Optim™ Query Tuner client is not a part of IBM® InfoSphere Optim Query Workload Tuner, Version 3.1.1. You must export your Query Tuner projects and install the IBM Data Studio full client into the package group where the InfoSphere Optim Query Tuner client is located.

About this task

The IBM Data Studio full client, Version 3.1.1 allows you to connect to DB2® databases and subsystems where licenses for IBM InfoSphere Optim Query Workload Tuner, Version 3.1 or 3.1.1 are active, and to use the full set of features for tuning queries and query workloads.

If you install the license activation kit for either IBM InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows, Version 3.1.1 or IBM InfoSphere Optim Query Workload Tuner for DB2 for z/OS®, Version 3.1.1 together with the IBM Data Studio full client, Version 3.1.1, you can activate licenses for those products on DB2 databases and subsystems. Activating a license on a DB2 database or subsystem allows anybody with access and who is using IBM Data Studio full client or administration client, Version 3.1.1 to use the full set of features for tuning queries and query workloads.

Procedure

To migrate from the InfoSphere Optim Query Tuner client to the IBM Data Studio full client, Version 3.1.1:

  1. Optional: Export your Query Tuner projects from the InfoSphere Optim Query Tuner client.
    1. In the InfoSphere Optim Query Tuner client, select File > Export.
    2. In the Export window, expand Query Tuner and select Projects.
    3. Select the projects that you want to export, select the directory to which you want to export them, and click Finish.
  2. Follow either of these steps:
  3. Start the IBM Data Studio full client. When Data Studio asks you to select a workspace, select the workspace that you used with the InfoSphere Optim Query Tuner client.
  4. If you find any problems with your Query Tuner projects, delete the ones in error and import them from the directory that you exported them to in step 1.