Authorities and privileges that 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.

Feedback