These authorities and privileges are
required for tuning SQL statements that run on DB2® for Linux, UNIX, and Windows.
For all supported versions of DB2
for Linux, UNIX, and Window, these authorities and privileges are
required:
- You must have SELECT, UPDATE, INSERT,
and DELETE privileges on the EXPLAIN and ADVISE tables. You must also
have the privilege to run the SYSPROC.EXPLAIN_SQL stored procedure.
- To run the Index Advisor and Workload Index Advisor
for DB2 for Linux, UNIX,
and Windows, you must have
the following additional privileges:
- CREATEIN privilege in the schema DB2OE, DBADM authority, or (for DB2 for Linux, UNIX,
and Windows V9.5 and earlier)
SYSADM authority to create the stored procedure DB2OE.CALLDB2ADVIS
- Permission to access the luwsp.jar file,
which by default is in the installation directory for the IBM Data Studio client
at C:\Program Files\IBM\OQT3.1\serverconfig\LUW\IA\.
- EXECUTE privilege against the DB2OE.CALLDB2ADVIS stored procedure
- You must have INSERT, DELETE, UPDATE,
and SELECT privileges on the SYSTOOLS.QT_WCC_* tables.
For supported versions earlier than 9.7, you must also
have EXECUTE privilege on the stored procedure SYSPROC.SNAP_GET_DYN_SQL_V95.