3495937 - DB6: SQL0551N error with SYSPROC.DB2_GET_INSTANCE_INFO

Symptom

"Time spent analysis" returns no data due to improper set up of data collector WLM Statistics.
You need to recreate this data collector.

During the recreation, you get following error:

SQL0551N The statement failed because the authorization ID does not have the required authorization or privilege to perform the operation.
Authorization ID: "DB2<SID>".
Operation: "EXECUTE".
Object: "SYSPROC.DB2_GET_INSTANCE_INFO".

Environment

SAP on IBM Db2 for Linux, Unix and Windows

Product

SAP ERP all versions

Keywords

Time Spent Analysis, WLM Statistics, SQL0551N, SYSPROC.DB2_GET_INSTANCE_INFO

, KBA , BC-DB-DB6-CCM , CCMS/Database Monitors , 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.