Packages required by the Optim Query Tuner client

You must bind certain packages to enable various functions of the Optim™ Query Tuner client on each DB2® for z/OS® subsystem that runs the SQL statements that you tune.
You can bind the packages by using the Optim Query Tuner client or by running an AOCDDL sample JCL job on the server side. After the packages are bound from a particular workstation, you do not need to bind again to connect from the Optim Query Tuner client on another workstation.

Basic packages

DSN5OADM
This package accesses catalog tables to check the existence of the objects, such as tables and databases that are used for query tuning. This package also checks the format of objects, such as tables and columns.
DSN5OEPJ
On a DB2 for z/OS Version 8 subsystem, this package accesses catalog information for any tables on which the EXPLAIN statement is issued. This package accesses information about columns, indexes, table spaces, and their statistics.
DSN5OEPK
On a DB2 for z/OS Version 9 or Version 10 subsystem, this package accesses catalog information for any tables on which the EXPLAIN statement is issued. This package accesses information about columns, indexes, table spaces, and their statistics.
DSN5ONPT
This package accesses QMF™ control tables in case the current user does not have SYSADM authority.
DSN5OPKG
This package accesses catalog tables to check the existence of the package, and retrieves the privileges that users have on the packages and tables.

Packages for SQL statements

AOC5OSA
For the Statistics Advisor, this package accesses statistics-profile tables that are used by the statistics advisor to manage the statistics profile.
AOC5OQA
For the Query Advisor, this package accesses catalog information for referential constraints between tables.
AOC5OQIA
For the Index Advisor, this package accesses the catalog tables to get the referential constraints, table definition, and statistics.
DSN5OFMJ
For the query annotation feature, this package accesses catalog tables on a DB2 for z/OS Version 8 or Version 9 subsystem. This package obtains the DDL statements for views and the materialized query tables.
DSN5OFMM
For the query annotation feature, this package accesses catalog tables on a DB2 for z/OS Version 10 subsystem. This package obtains the DDL statements for views and the materialized query tables.

Packages for query workloads

AOC5OCWP
For the SYSPROC.OPT_EXECUTE_TASK stored procedure, this package accesses the workload tables, catalog tables, and EXPLAIN tables under the DB2OSC schema on a DB2 for z/OS Version 8 compatibility mode subsystem.
AOC5OEXJ
For the SYSPROC.OPT_RUNSQL stored procedure, this package accesses workload tables and EXPLAIN tables under the DB2OSC schema on a DB2 for z/OS Version 8 new-function mode or Version 10 conversion mode from Version 8 subsystem.
AOC5OEXK
For the SYSPROC.OPT_RUNSQL stored procedure, this package accesses workload tables and EXPLAIN tables under the DB2OSC schema on a DB2 for z/OS Version 9 or Version 10 conversion mode from Version 9 subsystem.
AOC5OEXM
For the SYSPROC.OPT_RUNSQL stored procedure, this package accesses workload tables and EXPLAIN tables under the DB2OSC schema on a DB2 for z/OS Version 10 new-function mode subsystem.
AOC5OIAn where n={1-9, A-M}
For the Index Advisor, this package accesses the tables that are used by the Index Advisor to perform the workload-based index advisor process. This package also accesses the catalog tables to get referential constraints, table definitions, and statistics.
AOC5OSA
For the Statistics Advisor, this package accesses the statistics-profile tables that are used by the Statistics Advisor to manage the statistics profiles.
AOC5OWCJ
For the workload control center feature, this package accesses workload tables, catalog tables, and EXPLAIN tables under the DB2OSC schema on a DB2 for z/OS Version 8 new-function mode or Version 10 conversion mode from Version 8 subsystem.
AOC5OWCK
For the workload control center and workload monitoring features, this package accesses workload tables, catalog tables, profile tables, and EXPLAIN tables under the SYSIBM and DB2OSC schemas on a DB2 for z/OS Version 9 or Version 10 conversion mode from Version 9 subsystem.
AOC5OWCM
For the workload control center feature, this package accesses workload tables, catalog tables, and EXPLAIN tables under the DB2OSC schema on a DB2 for z/OS Version 10 new-function mode subsystem.
AOC5OWQA
For the Query Advisor, this package accesses tables that are used by the Query Advisor to manage the analysis session and corresponding operations.
AOC5OWSJ
For the SYSPROC.OPT_EXECUTE_TASK stored procedure, this package accesses workload tables, catalog tables, and EXPLAIN tables under the DB2OSC schema on a DB2 for z/OS Version 8 new-function mode or Version 10 conversion mode from Version 8 subsystem.
AOC5OWSK
For the SYSPROC.OPT_EXECUTE_TASK stored procedure, this package accesses workload tables, catalog tables, and EXPLAIN tables under the DB2OSC schema on a DB2 for z/OS Version 9 or Version 10 conversion mode from Version 9 subsystem.
AOC5OWSM
For the SYSPROC.OPT_EXECUTE_TASK stored procedure, this package accesses workload tables, catalog tables, and EXPLAIN tables under the DB2OSC schema on a DB2 for z/OS Version 10 new-function mode subsystem.
DSN5OCWA
For the Statistics Advisor, this package accesses tables that are used by the Statistics Advisor to manage the analysis session and corresponding operations on a DB2 for z/OS Version 8 compatibility mode subsystem.
DSN5OCWC
For the workload control center feature, this package accesses workload tables, catalog tables, and EXPLAIN tables under the DB2OSC schema on DB2 for z/OS Version 8 compatibility mode subsystem.
DSN5OWSA
For the Statistics Advisor, this package accesses tables that are used by the Statistics Advisor to manage the analysis session and corresponding operations on a DB2 for z/OS Version 8 new-function mode, Version 9, or Version 10 subsystem.

Package for access plan comparison

AOC5OAPC
For the access plan comparison feature, this package accesses the plan comparison table to perform the advisor process. It also accesses the catalog tables to get information about user-specified DB2 packages to be compared.

Feedback