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.
Procedure
To migrate the EXPLAIN and Query Tuner tables, packages,
and stored procedures from the server:
- 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.
- 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 |