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.
- 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.
- AOC5OFMJ
- For the query formatting 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 formatting 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.
- 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.
- AOC5OSA
- For the Statistics Advisor, this package accesses statistics-profile
tables that are used by the statistics advisor to manage the statistics
profile.
Optional packages
- 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.