All sources |
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)
|
Statement cache |
All of the following authorities and privileges:- EXECUTE privilege on SYSPROC.DSNWZP
- EXECUTE privilege on ADMIN_COMMAND_DB2 or SYSPROC.DSNACCMD
- For stored procedures, EXECUTE privilege on SYSPROC.OPT_RUN_SQL
and SYSPROC.OPT_EXECUTE_TASK
- The authorization ID is associated with the RACF® group DB2OSCA.
|
Catalog plan, or package |
All of the following authorities and privileges:- SELECT privilege on the following tables:
- SYSIBM.SYSPACKAGE
- SYSIBM.SYSPACKLIST
- SYSIBM.SYSPLAN
- SYSIBM.SYSSTMT
- SYSIBM.SYSPACKSTMT
- SYSIBM.SYSPACKDEP
- SYSIBM.SYSPLANDEP
- 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
|
QMF™ |
All of the following authorities and privileges:- SELECT privilege on the following tables:
- Q.OBJECT_DIRECTORY
- Q.OBJECT_DATA
- Q.OBJECT_REMARKS
- 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
- Select privileges on the Q.DSEQ_QMFOBJSL view (not required for
SYSADM)
|
QMF HPO |
All of the following authorities and privileges:- SELECT privilege on the Q.OBJ_ACTIVITY_SUMM and Q.OBJ_ACTIVITY_DTL
tables
- EXECUTE privileges on the following packages:
- AOC5OADM
- AOC5OEPJ (DB2 for z/OS Version 8)
- AOC5OEPK (DB2 for z/OS Versions 9 and 10)
- AOC5ONPT
- AOC5OPKG
|