Migrating a DB2 for z/OS subsystem for the current version of the Optim Query Tuner client from the server

If your DB2® for z/OS® subsystem is configured for the Optim™ Query Tuner client Version 2.2.0.2, you can run an AOCJOC JCL job to migrate the existing EXPLAIN and Query Tuner tables, packages, and stored procedures. You can also run an AOCTIJ JCL job to migrate these objects and facilities for the different versions of the DB2 subsystems.

Before you begin

You must have the authorities and privileges for migrating the EXPLAIN and Query Tuner tables.

Procedure

To migrate the EXPLAIN and Query Tuner tables, packages, and stored procedures from the server:

  1. If you did not perform the SMP/E tape installation to extract the files for migrating the subsystem, upload the required JCL job files to the subsystem from the client system. The files are installed with the Optim Query Tuner client. You can find the files in the \serverconfig\ZOS\migration subdirectory of the installation directory. The default installation directory is C:\Program Files\IBM\OQT2.2.1.
  2. On the subsystem, modify and submit the appropriate AOCJOC or AOCTIJ JCL job file. The following table lists the JCL job files for each environment.
    Migration path JCL job file
    Migrating the Optim Query Tuner client from Version 2.2.0.2 to Version 2.2.1 on a DB2 for z/OS Version 8 new-function mode subsystem AOCJOC8N
    Migrating the Optim Query Tuner client from Version 2.2.0.2 to Version 2.2.1 on a DB2 Version 9.1 for z/OS subsystem AOCJOC9
    Migrating the subsystem from DB2 for z/OS Version 8 new-function mode to DB2 Version 10 for z/OS conversion mode from Version 8 for the Optim Query Tuner client Version 2.2.1 AOCTIJC8
    Migrating the subsystem from DB2 Version 10 for z/OS conversion mode from Version 8 to DB2 Version 10 for z/OS new-function mode for the Optim Query Tuner client Version 2.2.1 AOCTIJ8X
    Migrating the subsystem from DB2 Version 9.1 for z/OS to DB2 Version 10 for z/OS conversion mode from Version 9 for the Optim Query Tuner client Version 2.2.1 AOCTIJC9
    Migrating the subsystem from DB2 Version 10 for z/OS conversion mode from Version 9 to DB2 Version 10 for z/OS new-function mode for the Optim Query Tuner client Version 2.2.1 AOCTIJ9X

Feedback