You can configure DB2® for z/OS® subsystems for use with the
no-charge tuning features by submitting a JCL job.
Before you begin
Ensure that the IBM® Data
Studio client, Version 3.2 is installed on a workstation that you
have access to.
About this task
If your subsystem was configured
for the no-charge tuning features that were in IBM Data Studio full client or administration
client, Version 3.1 or 3.1.1, then you do not need to follow the steps
in this procedure.
Procedure
Perform the following steps on the DB2 for z/OS subsystem
to configure it for tuning SQL statements:
- Upload the required JCL job files and DBRMs to the subsystem
from the client system.
The JCL files and DBRMs are
located inside the installation directory for the IBM Data Studio client.
- If you installed the IBM Data
Studio client on a Windows system,
the JCL is in the installation_directory\QueryTunerServerConfig\no_charge_features\ZOS\version_number_and_mode directory.
- If you installed the IBM Data
Studio client on a Linux system,
the JCL is in the .installation_directory/QueryTunerServerConfig/no_charge_features/ZOS/version_number_and_mode directory.
Upload the JCL files in ASCII format and the DBRMs in
binary format.
Table 1. JCL and DBRMs
for Version 9.1, Version 10 conversion mode from Version 9.1, and
Version 10 of DB2 for z/OS| Name of subfolder |
V9 |
V10CM8 |
V10CM9 |
V10 |
| List of files |
JCL: AOCDDL9
DBRMS: AOC5OADM AOC5OEPK AOC5OEXK AOC5OFMJ AOC5ONPT AOC5OPKG AOC5OSA |
JCL: AOCDDLX8
DBRMS: AOC5OADM
AOC5OEPK AOC5OEXJ AOC5OFMM AOC5ONPT AOC5OPKG AOC5OSA |
JCL: AOCDDLX9
DBRMS: AOC5OADM AOC5OEPK AOC5OEXK AOC5OFMM AOC5ONPT AOC5OPKG AOC5OSA |
JCL: AOCDDL10
DBRMS: AOC5OADM AOC5OEPK AOC5OEXM AOC5OFMM AOC5ONPT AOC5OPKG AOC5OSA |
- Create the tables for Version 4.1.0.1.
On the subsystem, modify the corresponding AOCDDL JCL job file to
conform to your environment, then submit the job. The following
table lists the AOCDDL JCL job files for each environment.
| DB2 subsystem |
JCL job to create the query tuning
tables for Version 4.1.0.1 |
| 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 for z/OS |
AOCDDL9 |