Packages to bind on DB2 for z/OS subsystems for the no-charge tuning features

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.

Feedback