Migrating objects created by version 3.2 to version 4.1

If you configured a subsystem for use with InfoSphere® Optim™ Query Workload Tuner, Version 3.2, you can migrate that configuration for use with version 4.1.

Procedure

To migrate objects created for use with version 3.2 to version 4.1:

  1. Upload the required JCL job files to the subsystem from the client system.
    The JCL files are located inside the installation directory for the IBM® Data Studio client.
    • If you installed the IBM Data Studio client on a Windows system, the JCL is in the installation_directory\QueryTunerServerConfig\all_features\ZOS\migration directory.
    • If you installed the IBM Data Studio client on a Linux system, the JCL is in the .installation_directory/QueryTunerServerConfig/all_features/ZOS/migration directory.
    Upload the JCL files in ASCII format.
    Version of DB2® for z/OS® on the subsystem JCL job
    DB2 10 for z/OS AOCOJOC10
    DB2 9.1 for z/OS AOCOJOC9
    DB2 10 for z/OS conversion mode from Version 9 AOCOJOCX9
    DB2 8 for z/OS new-function mode AOCOJOC8N
    DB2 10 for z/OS conversion mode from Version 8 AOCOJOCX8
  2. Modify the corresponding AOCDDL JCL job file to conform to your environment.
  3. Submit the job.

What to do next

Users of InfoSphere Optim Query Workload Tuner can now connect to the subsystem from IBM Data Studio client, Version 4.1 and start tuning SQL.

Feedback