| 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
- 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 |
The following authorities and privileges:- EXECUTE privilege on these packages:
- DB2OSC.AOC5OADM
- DB2OSC.AOC5OEPK
- DB2OSC.AOC5ONPT
- DB2OSC.AOC5OPKG
- DB2OSC.AOC5OWTA
- EXECUTE privilege on these stored procedures:
- SYSPROC.ACCEL_ADD_TABLES
- SYSPROC.DSNWZP
- SYSPROC.ADMIN_COMMAND_DB2
- SQLADM authority
- One of the following authorities:
|