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:
    • DB2OSC.AOC5OADM
    • DB2OSC.AOC5OEPK
    • DB2OSC.AOC5ONPT
    • DB2OSC.AOC5OPKG
    • DB2OSC.AOC5OSA
    • DB2OSC.AOC5OWSA
  • 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)
Workload Query Advisor All of the following authorities and privileges:
  • EXECUTE privilege on the following packages:
    • DB2OSC.AOC5OADM
    • DB2OSC.AOC5OEPK
    • DB2OSC.AOC5ONPT
    • DB2OSC.AOC5OPKG
    • AOC5OWQA
  • SELECT privilege on catalog tables
Workload Index Advisor
  • To run the advisor:
    • EXECUTE privilege on the following packages:
      • DB2OSC.AOC5OADM
      • DB2OSC.AOC5OEPK
      • DB2OSC.AOC5ONPT
      • DB2OSC.AOC5OPKG
      • AOC5OIAn, where n={1-9, A-M}
    • SYSADM authority or EXECUTE privilege on the EXPLAIN stored procedure (DSNAEXP) and a secondary authorization ID that is part of the DB2OE RACF® group.
  • To create the recommended indexes, one of the following authorities or privileges:
    • INDEX privilege on the table
    • Ownership of the table
    • DBADM authority for database that contains the table
    • SYSADM or SYSCTRL authority
  • To use the what-if analysis:
    • SYSADM authority or EXECUTE privilege on the EXPLAIN stored procedure (DSNAEXP) and a secondary authorization ID that is part of the DB2OE RACF group.
Workload Analytics Acceleration Advisor See Prerequisites for the Workload Analytics Acceleration Advisor.

Feedback