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