To follow these steps, you must be using InfoSphere® Optim™ Query Workload Tuner for DB2® for z/OS®, Version 4.1.1.
To create missing Query Tuner tables and views:
To recreate Query Tuner tables and views that are in an unknown format by using the IBM® Data Studio client:
To recreate Query Tuner tables and views that are in an unknown format by running JCL:
The JCL files are located in the installation directory for the IBM® Data Studio client.
| Name of subfolder | V9 | V10CM9 | V10 | V11 |
|---|---|---|---|---|
| JCL file | AOCDDL9 | AOCDDLX9 | AOCDDL10 | AOCDDL11 |
//* AOCSA Step Create QT SA profile objects
//* AOCAPC Step Create QT Plan Comparision objects
//* AOCWCC Step Create QT WCC objects
//* AOCWSA Step Create QT WSA objects
//* AOCWIA Step Create QT WIA objects
//* AOCWAPC Step Create QT WAPC objects
…
//* AOCGRT Step Grant access on objects created by this job,
//* add grant package
//* AOCGRT2 Step Grant access on workload tables to individual
//* authorization ID. Not required if secondary
//* authorization ID is supported.