Question Re: SQL0551N The statement failed because the authorization ID error in Technology Q&A

SQL0551N The statement failed because the authorization ID error

Former Member — Wed, 04 Nov 2015 02:44:56 GMT

Hi All

I am getting the following error after upgrading to db2 database to 10.5

> SQL0551N The statement failed because the authorization ID

> does not have the required authorization or privilege to

> perform the operation. Authorization ID: "DB2BWQ".

> Operation: "SELECT". Object: "SYSIBMADM.DB2_CF".

> SQLSTATE=42501

Database error -551

Database error -551 at OPC

Refer to attachment attach :-

Please advice

Regards

Clement

Former Member — Wed, 04 Nov 2015 06:20:38 GMT

Hi Clement,

Please go through below sap notes and implement, if applicable.

1557981 - DB6: Adjustments in DBA cockpit for new database versions.

1409540 - DB6: CCMS Adaptations for Db2 version 10.1

Regards,

Prithviraj.

Former Member — Wed, 04 Nov 2015 07:10:36 GMT

Hi there

Not applicable . Anyway thanks

Regards

Clement

Former Member — Wed, 04 Nov 2015 08:16:30 GMT

Please go through below blog.

The issue in your case is db2<SID> user does not have Select permission on SYSIBMADM.DB2_CF object.

Regards,

Prithviraj.