You can configure a DB2® for z/OS® subsystem to
tune single SQL statements with IBM® Data
Studio from
the server. The required packages, tables, authorities, and privileges
can be enabled by running a JCL job.
Procedure
Perform the following steps on the DB2 for z/OS subsystem
to configure it for tuning SQL statements:
- Upload the required DBRM and JCL job files to
the subsystem. The files are installed with Data Studio.
You
can find these files in the following location:
- For Data Studio Integrated Development Environment package: Installation_directory\dsmini\serverconfig\ZOS\z/OS_version_number_and_mode
- For Data Studio stand-alone package: Installation_directory\dsrcp\serverconfig\ZOS\z/OS_version_number_and_mode
Note: Use binary format when you upload these DBRM files
to the subsystem.
- Modify the corresponding AOCDDL JCL job file in
the following table to conform to your environment, and submit the
job to install the DBRM files and create EXPLAIN tables.
Subsystem |
JCL job file |
DB2 Version
10 for z/OS new-function
mode |
AOCDDL10 |
DB2 Version
10 for z/OS conversion
mode from Version 9 |
AOCDDLX9 |
DB2 Version
10 for z/OS conversion
mode from Version 8 |
AOCDDLX8 |
DB2 Version
9.1 for z/OS |
AOCDDL9 |
DB2 for z/OS Version 8 new-function
mode |
AOCDDL8N |
DB2 for z/OS Version 8 compatibility
mode |
AOCDDL8C |