These authorities and privileges are required for running
the workload advisors and implementing the recommendations of the
Workload Statistics Advisor and the Workload Index Advisor.
Table 1. Authorities and privileges required to run the workload advisorsAdvisor |
Authorities and privileges required |
Workload Statistics Advisor |
- To run the 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
- AOC5OSA
- AOC5OCWA (DB2 for z/OS Version 8 CM)
- AOC5OWSA (DB2 for z/OS Versions 8 NFM, 9, and 10)
- 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)
|