| Workload Statistics Advisor |
- To run the advisor, 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
- AOC5OSA
- AOC5OCWA (DB2 for z/OS Version 8 CM)
- AOC5OWSA (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)
|
| Workload Query Advisor |
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
- SELECT privilege on catalog tables
|
| Workload Index Advisor |
- To run the advisor:
- 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
- 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.
|