SQL0551N The statement failed because the authorization ID error

[Former Member]

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]

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]

Hi there

Not applicable . Anyway thanks

Regards

Clement

[Former Member]

Hi

Please go through below blog.

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

IBM Authorization errors due to changes to the SYSADM authority scope - United States

https://scn.sap.com/thread/158547

Regards,

Prithviraj.