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 EXPLAIN and ADVISE tables. You must also
have the privilege to run the SYSPROC.EXPLAIN_SQL stored procedure.
To run the 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