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® subsystem 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.
AOC5OEPK (DB2 Version 9.1 for z/OS only)
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.
AOC5OEPL (DB2 10 for z/OS or later)
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 (DB2 Version 9.1 for z/OS, DB2 10 for z/OS, and DB2 11 for z/OS conversion mode)
This package accesses catalog tables to check the existence of the package, and retrieves the privileges that users have on the packages and tables.
AOC5OPKN (DB2 11 for z/OS new-function mode)
This package accesses catalog tables to check the existence of the package, and retrieves the privileges that users have on the packages and tables.

Package that is required for the Statistics Collection Advisor

AO5OSCM (DB2 11 for z/OS or later)
This package contains static SQL statements that are used by the Statistics Collection Advisor.

Packages that are required for tuning SQL statements

AOC5OEO (DB2 11 for z/OS new-function mode or later)
This package contains SQL statements for the selectivity override feature.
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 referential constraints, table definitions, and statistics.
AOC5OFMJ
For the query annotation feature, this package accesses catalog tables on a DB2 for z/OS 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 or Version 11 subsystem. This package obtains the DDL statements for views and the materialized query tables.

Packages that are required for tuning query workloads

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 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, Version 11, or Version 11 conversion 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.
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 that is required for recommendations for adding tables to accelerators in DB2 Analytics Accelerator

AOC5OWTA
For the Workload Analytics Acceleration Advisor, this package access the SYSACCEL.SYSACCELERATORS and SYSACCEL.SYSACCELERATEDTABLES, as well as workload tables, catalog tables, and EXPLAIN tables.

Package that is 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.

Feedback