If you configured a subsystem for use with InfoSphere®
Optim™ Query Workload Tuner, Version 4.1, you can migrate that
configuration for use with version 4.1.1.
Procedure
To migrate objects created for use with version 4.1 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 11 for z/OS new-function mode |
AOCJOM11 |
| DB2 11 for z/OS conversion mode |
AOCJOMBC |
| 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 10
for z/OS conversion mode from
Version 8 |
AOCOJOCX8 |
- Modify the corresponding AOCDDL JCL job file to conform
to your environment.
- 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.1 and start tuning SQL.