Configuring DB2 for z/OS subsystems for Visual Explain from the server

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.

Before you begin

Procedure

Perform the following steps on the subsystem to configure it for Visual Explain:

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

Feedback