Authorities and privileges required for managing query workloads

These authorities and privileges are required for managing query workloads.
Table 1. Authorities and privileges required to perform workload management tasks
Task Authorities and privileges required
Schedule workload tasks All of the following authorities and privileges:
  • 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
    • AOC5OFMJ (DB2 for z/OS Versions 8 and 9)
    • AOC5OFMM (DB2 for z/OS Version 10)
    • AOC5OWCJ (DB2 for z/OS Versions 8 NFM and 10 CM8)
    • AOC5OWCK (DB2 for z/OS Version 10 CM9)
    • AOC5OWCM (DB2 for z/OS Version 10 NFM)
  • The authorization ID is associated with the RACF® group DB2OSCA.
  • If you want to use the administrative scheduler: EXECUTE privilege on the SYSPROC.OPT_EXECUTE_TASK and SYSPROC.OPT_RUNSQL stored procedures.
EXPLAIN workloads Might need EXECUTE privilege on the following stored procedures:
  • SYSPROC.DSNAEXP
  • SYSPROC.DSNAHVPM
Manage workload users All of the following authorities and privileges:
  • 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
    • AOC5OFMJ (DB2 for z/OS Versions 8 and 9)
    • AOC5OFMM (DB2 for z/OS Version 10)
    • AOC5OWCJ (DB2 for z/OS Versions 8 NFM and 10 CM8)
    • AOC5OWCK (DB2 for z/OS Version 10 CM9)
    • AOC5OWCM (DB2 for z/OS Version 10 NFM)
  • The authorization ID is associated with the RACF group DB2OSCA.
View workload history All of the following authorities and privileges:
  • 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
    • AOC5OFMJ (DB2 for z/OS Versions 8 and 9)
    • AOC5OFMM (DB2 for z/OS Version 10)
    • AOC5OWCJ (DB2 for z/OS Versions 8 NFM and 10 CM8)
    • AOC5OWCK (DB2 for z/OS Version 10 CM9)
    • AOC5OWCM (DB2 for z/OS Version 10 NFM)
  • The authorization ID is associated with the RACF group DB2OSCA.

Feedback