| 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
|
| SQL category |
None |
| File |
None |
| Function table |
All of the following authorities and privileges:- SELECT privilege on the following tables:
- DSN_FUNCTION_TABLE
- SYSIBM.SYSPACKAGE
- SYSIBM.SYSPACKLIST
- SYSIBM.SYSPLAN
- SYSIBM.SYSSTMT
- SYSIBM.SYSPACKSTMT
- 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
|
| Plan table |
All of the following authorities and privileges:- SELECT privilege on the following tables:
- PLAN_TABLE
- SYSIBM.SYSPACKAGE
- SYSIBM.SYSPACKLIST
- SYSIBM.SYSPLAN
- SYSIBM.SYSSTMT
- SYSIBM.SYSPACKSTMT
- 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
|
| SQL procedure |
SELECT privilege on the system catalog. |
| SQL user-defined function |
SELECT privilege on the system catalog. |
| Statement cache |
All of the following authorities and privileges:- EXECUTE privilege on the EXPLAIN STMTCACHE ALL statement, either
dynamically or through the SYSPROC.OSC_RUNSQL stored procedure:
- Dynamically: SYSADM authority is needed to run EXPLAIN for all
statements, otherwise only statements with the same authorization
ID can be explained.
- By stored procedure: EXECUTE privilege is required for the SYSPROC.OSC_RUNSQL
stored procedure, which explains all statements.
- Ownership of DSN_STATEMENT_CACHE_TABLE, or ownership of an alias
on owner.DSN_STATEMENT_CACHE_TABLE, and SELECT,
INSERT and DELETE privileges on the table.
- 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
- Optional: To get statistics information (such as CPU time and
elapsed time) EXECUTE privilege on the SYSPROC.ADMIN_COMMAND_DB2 stored
procedure is needed to start and stop the trace.
|
| Statement table |
All of the following authorities and privileges:- SELECT privilege on the following tables:
- DSN_STATEMNT_TABLE
- SYSIBM.SYSPACKAGE
- SYSIBM.SYSPACKLIST
- SYSIBM.SYSPLAN
- SYSIBM.SYSSTMT
- SYSIBM.SYSPACKSTMT
- EXECUTE on the following packages:
- AOC5OADM
- AOC5OEPJ (DB2 for z/OS Version 8)
- AOC5OEPK (DB2 for z/OS Versions 9 and 10)
- AOC5ONPT
- AOC5OPKG
|
| Text |
None. |
| Trigger |
SELECT privilege on the system catalog. |
| View |
SELECT privilege on the system catalog. |