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 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.