Authorities and privileges required for analyzing and tuning query workloads 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.

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