You can configure a DB2® for z/OS® subsystem for Visual
Explain from the server. The required packages and tables can be created
and enabled by running a JCL job from the server.
Procedure
Perform the following steps on the subsystem
to configure it for Visual Explain:
- Upload the required DBRM and JCL job files to
the subsystem. The files are installed with the product
that you are using. The files are in the \serverconfig\ZOS\z/OS_version_number_and_mode subdirectory
of the installation directory. The default installation directory
is C:\Program Files\IBM\product.
Note: Use
binary format when you upload these DBRM files to the subsystem.
- Modify the appropriate AOCDDL JCL job file from
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 |
Results
After you successfully configured the subsystems, you can
use Visual Explain to view the access plan graph of your SQL statements.
What to do next
To open Visual Explain, see
Diagramming access plans with Visual Explain.