Packages that are required to be bound on DB2 for z/OS subsystems that are used with InfoSphere® Optim™ Query Workload Tuner

On each DB2® for z/OS® that runs the SQL statements that you tune, you must bind certain packages to enable various functions of the IBM® Data Studio client.

You can bind the packages by using the IBM Data Studio client or by running an AOCDDL sample JCL job. After the packages are bound from a particular workstation, you do not need to bind again to connect from the IBM Data Studio client on another workstation.

Basic packages

AOC5OADM
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.
AOC5OEPJ
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.
AOC5OEPK
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.
AOC5ONPT
This package accesses QMF™ control tables in case the current user does not have SYSADM authority.
AOC5OPKG
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 required for tuning 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.
AOC5OFMJ
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.
AOC5OFMM
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 required for tuning 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.
AOC5OCWA
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.
AOC5OCWC
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.
AOC5OWSA
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 required for comparing access plans

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.