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
- AOC5OEPJ (DB2® for z/OS® Version 8)
- AOC5OEPK (DB2 for z/OS Versions 9 and 10)
- AOC5ONPT
- AOC5OPKG
- 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)