Configuring DB2 for z/OS subsystems for Visual Explain by using DBRM and JCL job files

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:

Procedure

To configure a DB2 for z/OS subsystem for Visual Explain:

  1. 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.
  2. 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

Feedback