Grant EXECUTE authority on the plan CAZPLAN1 to the authorization
ID of the Application Performance Analyzer started task. You can use the following SQL
statement to grant this privilege:
GRANT EXECUTE ON PLAN CAZPLAN1 TO authid
Note: CAZPLAN1 is the default plan name. If you have
chosen to use a different plan name, then replace CAZPLAN1 with the
plan name that was used to BIND the Application Performance Analyzer DB2 Plan.
Additionally, if you want to use the DB2® EXPLAIN feature, the authorization ID of the
started task must have SYSADM authority. Having SYSADM authority allows
the started task to perform functions such as setting the CURRENT
SQLID (or SCHEMA) to the qualifier for a target SQL statement. You
can use the following SQL statement to grant SYSADM privilege:
GRANT SYSADM TO authid