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 create missing EXPLAIN tables or recreate ones 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 fo z/OS| Name of subfolder |
V9 |
V10CM9 |
V10 |
V11 |
| JCL file |
AOCDDL9 |
AOCDDLX9 |
AOCDDL10 |
AOCDDL11 |
- Upload the JCL job file to the subsystem from the client system
in ASCII format.
- Comment out all job steps except AOCEXPCU and AOCEXP.
- Modify the JCL job file to conform to your environment, then
submit the job.