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 full
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
that are 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
that are 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 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.