These
authorities and privileges are required for tuning
SQL statements that run on DB2® for Linux, UNIX, and Windows.
You must have SELECT, UPDATE, INSERT, and DELETE
privileges
on the SYSTOOLS EXPLAIN and ADVISE tables. You must also have the
privilege to run the SYSPROC.EXPLAIN_SQL stored procedure.
To
run Index Advisor for DB2 for Linux, UNIX, and Windows,
you must have the following additional privileges:
- CREATE IN
privilege for DB2OE, DBADM, or SYSADM (for DB2 for Linux, UNIX, and Windows V9.5 and earlier) authority to create
the stored procedure DB2OE.CALLDB2ADVIS
- Permission to access
the luwsp.jar file,
which by default is located in the installation directory for the Optim™ Query Tuner client
at C:\Program Files\IBM\OQT2.2.1\serverconfig\LUW\SP\.
- EXECUTE privilege against the DB2OE.CALLDB2ADVIS stored procedure