These authorities and privileges are required to run the
Statistics Advisor when you are using the no-charge features of the Query
Tuner Workflow Assistant.
- To run the Statistics Advisor, EXECUTE privilege on the following
packages:
- AOC5OADM
- AOC5OEPK (DB2® for z/OS® Versions 9 and 10)
- AOC5ONPT
- AOC5OPKG (DB2 for z/OS Versions 9, 10, and 11 conversion mode)
- AOC5OPKN (DB2 for z/OS Version 11 new-function mode)
- To run the recommended RUNSTATS job, EXECUTE privilege on the
SYSPROC.DSNUTILU stored procedure
- To save recommended RUNSTATS jobs or retrieve previously saved
jobs from the profile tables, EXECUTE privilege on the statistics
advisor package (AOC5OSA)