You can run a JCL job to configure a DB2® for z/OS® subsystem for Visual
Explain.
Before you begin
You must install any of these products:
- Data Studio
- InfoSphere™ Data Architect
- Optim™ Database Administrator
- Optim Development Studio
Procedure
To configure a DB2 for z/OS subsystem for Visual
Explain:
- Upload the required DBRM and JCL job files to
the subsystem. The files are installed along with the product
that you are using. You can find the files in the \serverconfig\ZOS\V<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 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 |