3522115 - SQL0551N "SAP<SID>" does not have the required authorization or privilege to perform operation "EXECUTE" on object "SAPTOOLS.SNAP_GET_DYN_SQL". Db2 9.7

Symptom

In Db2 9.7, after running the db6_update_db.sh -m -d <SID> update script the following error is returned.
SQL0551N "SAP<SID>" does not have the required authorization or privilege to perform operation "EXECUTE" on object "SAPTOOLS.SNAP_GET_DYN_SQL". Db2 9.7

" does not have the required authorization or privilege to perform operation "EXECUTE" on object "SAPTOOLS.SNAP_GET_DYN_SQL". Db2 9.7"> Read more...

Environment

Db2 LUW IBM

Keywords

self monitoring, DBAcockpit, Data Collector Performance, Data Collectors, Routines, Functions, , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.