Authorities and privileges required for tuning SQL statements that run on DB2 for Linux, UNIX, and Windows

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

Feedback