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:
- 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 |
- 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 and start tuning SQL.