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.


Feedback