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
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
[ Top of Page | Previous Page | Next Page | Contents | Index ]