If the Workload Analytics Acceleration Advisor is not able to run, check the items in
this list.
- Ensure that one of the following APARs or PTFs in applied to the DB2 for z/OS subsystem that you
are connected to:
- DB2 Version 9 for z/OS:
APAR PM53634 / PTF UK76161
- DB2 10 for z/OS:
APAR PM50434 / PTF UK76103
- Ensure that these packages are bound and that your authorization ID is granted the EXECUTE
privilege on them.
- DB2OSC.AOC5OADM
- DB2OSC.AOC5OEPK
- DB2OSC.AOC5ONPT
- DB2OSC.AOC5OPKG (DB2® Version 9.1 for z/OS® and DB2 10 for z/OS) or DB2OSC.AOC5OPKN (DB2 11 for z/OS new-function mode or later)
- DB2OSC.AOC5OWTA
These packages are bound as part of the configuration of a subsystem for use with InfoSphere
Optim Query Workload Tuner for DB2 for z/OS, Version 4.1.0.1 or later. If the package is missing
from the subsystem, you can bind it in one of two ways:- In the Data Source Explorer, right-click the subsystem and select . In the Query Tuner section of the window that opens, click
Bind. After the BIND operation is finished, click the Manage Package
Privileges icon (
) in the toolbar near the top of the window. In the window that opens, follow the
instructions to grant privileges in the column Workload Analytics Acceleration
Advisor. This column is on the far right side of the table, so you must scroll to see
it.
- In the installation directory of the IBM Data Studio client, Version 4.1.0.1, locate the DBRM
AOC5OWTA and AOCDDL* file for your version of DB2 for z/OS.
- If you installed the IBM® Data Studio client on a Windows system, the JCL is in the
installation_directory\QueryTunerServerConfig\all_features\ZOS\version_number_and_mode
directory.
- If you installed the IBM Data Studio client on a Linux system, the JCL is in the
.installation_directory/QueryTunerServerConfig/all_features/ZOS/version_number_and_mode
directory.
Upload the files to the subsystem, the JCL file in ASCII format and the DBRM in binary format.
Run the job steps AOCBIND and AOCGRT.
- Ensure that these stored procedures are installed and that your authorization ID has the EXECUTE
privilege on them.
- SYSPROC.DSNWZP
- SYSPROC.ADMIN_COMMAND_DB2
- Ensure that your authorization ID has the SQLADM authority and one of the following authorities:
- If the button Add Recommended Tables to Accelerator above the list of
recommendations from the Workload Analytics Acceleration Advisor is not enabled, install
PTF UK82772, install the stored procedure SYSPROC.ACCEL_ADD_TABLES, and then
grant the EXECUTE privilege to the authorization ID of the person who is using the Workload
Analytics Acceleration Advisor.