Configuring a DB2 for z/OS subsystem from the server to tune SQL statements with IBM Data Studio

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:

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

Results

If you successfully configured the subsystem, you can access the Data Studio IDE and Data Studio stand-alone features. For a list of features, see Single-query tuning features by product.

Feedback