Installation directories and data sets

Before you begin to install and configure SQL Tuning Services, familiarize yourself with the product materials that are available after the SMP/E installation.

After SQL Tuning Services has been installed on your z/OS® system by following the instructions in the Program Directory for the product that you are installing (the IBM® Database Services Expansion Pack Program Directory or the Db2® Query Workload Tuner for z/OS Program Directory), some SQL Tuning Services components will be in a UNIX System Services directory and some components will be in partitioned data sets.
  • By default, the UNIX System Services components are installed in the /usr/lpp/IBM/db2tms/v2r1 directory, which is the parent folder of the SQL Tuning Services file system paths that are defined for DDNAME SDSN5TZF in the DSN5TDEF job. This directory is referred to as the install_dir_zos directory. For example, if the PATH of SDSN5TZF is defined to be /usr/lpp/IBM/db2tms/v2r1/IBM, the structure of install_dir_zos looks similar to the following example:
    
_Dir      755   OMVSKERN         8192   tmsinstall
_Dir      755   OMVSKERN         8192   tmsservice
_Dir      755   OMVSKERN         8192   IBM

    The install_dir_zos/IBM directory contains two files: the DSN5DTMS pax file and the DSN5INSH script for unpacking the DSN5DTMS pax file.

  • Two partitioned data sets are created to contain the following components:
    hlq. SDSN5TSA
    This data set contains the sample JCL.
    hlq. SDSN5TDB
    This data set contains the DBRMs.