Authorities and privileges for running workload advisors

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 basic packages (DSN5OADM, DSN5OEPJ (DB2® for z/OS® Version 8), DSN5OEPK (DB2 for z/OS Versions 9 and 10), DSN5ONPT, DSN5OPKG) and Workload Statistics Advisor packages (AOC5OSA, DSN5OCWA (DB2 for z/OS Version 8 CM), DSN5OWSA (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