Authorities and privileges for running workload advisors on query workloads that run on DB2 for z/OS

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 advisors
Advisor 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)

Feedback