Authorities and privileges required for analyzing and tuning query workloads

These authorities and privileges are required for tuning SQL statements that run on DB2® for Linux, UNIX, and Windows.

For all supported versions of DB2 for Linux, UNIX, and Window, these authorities and privileges are required:

For supported versions earlier than 9.7, you must also have EXECUTE privilege on the stored procedure SYSPROC.SNAP_GET_DYN_SQL_V95.


Feedback