为什么实例用户db2inst3都没有权限执行如下语句:db2 "SELECT MEMBER,SECTION_TYPE , TOTAL_CPU_TIME/NUM_EXEC_WITH_METRICS as AVG_CPU_TIME,EXECUTABLE_ID FROM TABLE(MON_GET_PKG_CACHE_STMT ( 'D', NULL, NULL, -2)) as T WHERE T.NUM_EXEC_WITH_METRICS ...
显示全部为什么实例用户db2inst3都没有权限执行如下语句:
db2 "SELECT MEMBER,SECTION_TYPE , TOTAL_CPU_TIME/NUM_EXEC_WITH_METRICS as AVG_CPU_TIME,EXECUTABLE_ID FROM TABLE(MON_GET_PKG_CACHE_STMT ( 'D', NULL, NULL, -2)) as T WHERE T.NUM_EXEC_WITH_METRICS <> 0 ORDER BY AVG_CPU_TIME fetch first 10 rows only"
SQL0551N "DB2INST3" does not have the required authorization or privilege to
perform operation "EXECUTE" on object "SYSPROC.MON_GET_PKG_CACHE_STMT".
SQLSTATE=42501
收起