Follow these steps when an error message requires you to
create missing EXPLAIN tables or to recreate them.
To follow these steps, you must be using InfoSphere® Optim™ Query Workload Tuner for DB2® for z/OS®,
Version 4.1.0.1.
To create missing EXPLAIN tables:- In the Data Source Explorer, expand the connection to the subsystem.
- Right-click the subsystem and select .
- Click Detailed Report.
- Review the DDL statements that are in the section DDL
for missing tables.
- Save the DDL to a file and run it in the tool of your choice.
To recreate EXPLAIN tables that
are in an unknown format by using the IBM® Data
Studio client:- In the Data Source Explorer, expand the connection to the subsystem.
- Right-click the subsystem and select .
- In the EXPLAIN Tables section, click the Create EXPLAIN
Tables icon.
To recreate EXPLAIN tables that are in an unknown format
by running JCL:- Locate the JCL job file for the version of DB2 for z/OS that
you are running.
The JCL files are located in 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\version_number_and_mode directory.
- If you installed the IBM Data
Studio client on a Linux system,
the JCL is in the installation_directory/QueryTunerServerConfig/all_features/ZOS/version_number_and_mode directory.
Table 1. JCL files for the supported
versions of DB2 for z/OS| Name of subfolder |
V9 |
V10CM8 |
V10CM9 |
V10 |
| JCL file |
AOCDDL9 |
AOCDDLX8 |
AOCDDLX9 |
AOCDDL10 |
- Upload the JCL job file to the subsystem from the client system
in ASCII format.
- Comment out all of the job steps except AOCEXPCU and AOCEXP.
- Modify the JCL job file to conform to your environment, then
submit the job.