The JCL files that you can choose from are installed with the IBM Data Studio client. You can find the them in the \QueryTunerServerConfig\ZOS\migration subdirectory of the installation directory.
| Version of DB2® for z/OS® on the subsystem | JCL job file |
|---|---|
| DB2 for z/OS Version 8 new-function mode subsystem | AOCM2B8N |
| DB2 Version 9 for z/OS subsystem | AOCM2B9 |
| DB2 Version 10 for z/OS conversion mode from DB2 for z/OS Version 8 subsystem | AOCM2BX8 |
| DB2 Version 10 for z/OS conversion mode from DB2 Version 9 for z/OS subsystem | AOCM2BX9 |
| DB2 Version 10 for z/OS subsystem | AOCM2BXN |
| Task | Authorities or privileges required |
|---|---|
| Bind packages | One of the following authorities and privileges:
|
| Free packages | One of the following authorities and privileges:
|
| Browse subsystem parameters | Both of the following authorities and privileges:
|
| Manage users | One of the following privileges or authorities:
|
| Create EXPLAIN tables | If you want to create the EXPLAIN tables in
a new database, one or more of the following privileges or authorities
for creating the database:
|
| Create aliases for existing EXPLAIN tables | One of the following privileges or authorities:
|
).If the license for InfoSphere Optim Query Workload Tuner is not yet active on the subsystem by this point, the Data Studio client installs the license on the subsystem and activates the license, if the license activation kit is installed in the directory where the Data Studio client is installed on your workstation. The configuration wizard allows you to configure the subsystem for query tuning and query-workload tuning.
| DB2 subsystem | JCL job to load data to the query tuning tables |
|---|---|
| DB2 for z/OS Version 8 new-function mode subsystem | AOCM2F8N |
| DB2 Version 9 for z/OS subsystem | AOCM2F9 |
| DB2 Version 10 for z/OS conversion mode from DB2 for z/OS Version 8 subsystem | AOCM2FX8 |
| DB2 Version 10 for z/OS conversion mode from DB2 Version 9 for z/OS subsystem | AOCM2FX9 |
| DB2 Version 10 for z/OS subsystem | AOCM2FXN |
You can check the status of the Query Tuner packages, Query Tuner tables, EXPLAIN tables, and the query or query-workload tuning features in this window.