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