Migrating the InfoSphere Optim Query Tuner client, Version 3.1 to IBM Data Studio full client, Version 3.1.1, and activating the license for InfoSphere Optim Query Workload Tuner for DB2 for z/OS, Version 3.1.1

Follow these instructions to migrate from InfoSphere Optim Query Tuner, Version 3.1 or InfoSphere Optim Query Workload Tuner, Version 3.1 to InfoSphere Optim Query Workload Tuner for DB2 for z/OS, Version 3.1.1.

Before you begin

About this task

The features for query and query-workload tuning with InfoSphere Optim Query Workload Tuner for DB2 for z/OS, Version 3.1.1 are located in the IBM Data Studio full client and administration client. To use the full set of features for tuning queries and query workloads that run on a subsystem, you must activate the license for InfoSphere Optim Query Workload Tuner for DB2 for z/OS. If you do not activate the license, you are limited to using the no-charge tuning features.

To activate the license, you must create the required files on a client machine where IBM Data Studio full client is installed. You create these files by running the License Activation Kit. You need to run this kit on only one client machine. Use the IBM Data Studio full client on that machine to connect to a DB2 for LUW database for the first time. The IBM Data Studio full client will recognize that the InfoSphere Optim Query Workload Tuner license is not yet activated on the database, and the client will activate the license. Subsequent users can connect to that database through IBM Data Studio full client or IBM Data Studio administration client and use InfoSphere Optim Query Workload Tuner, even if the License Activation Kit was not run on their client machine.

Procedure

To migrate to InfoSphere Optim Query Workload Tuner for DB2 for z/OS, Version 3.1.1:

Restriction: You cannot follow these steps to migrate from releases of InfoSphere Optim Query Tuner for DB2 for z/OS or InfoSphere Optim Query Workload Tuner for DB2 for z/OS that are earlier than version 3.1. You must uninstall the InfoSphere Optim Query Tuner client and then follow the steps in

  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. Install IBM Data Studio full client, Version 3.1.1.
    On the Install Packages page of the IBM Installation Manager wizard, select the option Use the existing package group. Then, select the package group IBM InfoSphere Optim.
  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.
  5. Run the License Activation Kit. The kit installs files that allow you to activate licenses for InfoSphere Optim Query Workload Tuner on supported DB2 for Linux, UNIX, and Windows databases.
    Note: Only the person or persons who will activate the license on databases are required to follow this step.
  6. Optional: Configure the database by running scripts, which are located in the installation directory for IBM Data Studio full client.
    • If you installed IBM Data Studio full client on a computer that is running a supported version of Windows: Follow the instructions that are in the file <installation directory>\QueryTunerServerConfig\all_features\LUW\enablement_win.bat.
    • If you installed IBM Data Studio full client on a computer that is running a supported version of Linux or UNIX: Follow the instructions that are in the file <installation directory>/QueryTunerServerConfig/all_features/LUW\enablement_LinuxUnix.sh.
  7. In IBM Data Studio full client, connect to a DB2 for Linux, UNIX, and Windows database in either the Data Source Explorer or the Administration Explorer.
  8. Follow the step that corresponds to the view that you used to connect to the database.
    • In the Data Source Explorer, select Analyze and Tune > Start Tuning.
    • In the Administration Explorer, select Start Tuning.

    If you did step 7, the Query Tuner Workflow Assistant opens to the Capture section, from which you can locate the SQL statements that you want to tune.

    If you did not do step 7, the Query Tuner Workflow Assistant automatically configures the database, if your user ID has the correct authorities and privileges. As part of this configuration process, the Query Tuner Workflow Assistant creates a set of EXPLAIN tables in the SYSTOOLS schema.

    In both cases, the license for InfoSphere Optim Query Workload Tuner is now activated on the DB2 for Linux, UNIX, and Windows database on which you did steps 7 through 9. You can proceed with using the full set of features for tuning queries and query workloads on that database. Moreover, other users of IBM Data Studio full client and users of IBM Data Studio administration client can also use the full set of tuning features on that database, if they have the necessary authorizations and privileges.

  9. Follow steps 7 through 9 for every DB2 for Linux, UNIX, and Windows database on which you want to activate the license for the full set of tuning features.