Symptom
The SWPM tool cannot continue as the developer trace files for all work processes fail with a DB-connection issue.
The DB connection fails for the <SID>adm user from the application server instance.
Errors like the following are observed. Note :some objects can be Virtual Tables. This is identified by SQL0551N error.
The object should then be checked in the DBAcockpit - Virtual tables overview and where needed the object(table) should be
materialsed in the same view.
dev_w0:
ERROR in prepareStatement[/bas/753_REL/src/dbs/db6/dbdb6.c, 15242]
DbSlConnectDB6( SQLExtendedPrepare ): [IBM][CLI Driver][DB2/LINUXX8664]
SQL0551N The statement failed because the authorization ID does not have the required authorization or privilege to perform the operation. Authorization ID: "<SID>ADM". Operation: "SELECT". Object: "SAP<SID>.<tab_name>".
Note: the above operation can include SELECT, EXECUTE etc.
Read more...
Environment
Db2 LUW IBM
Product
Keywords
installation, application server, SCHEMA, Deferred table creation, view, DB6_OPTPROFILE, ENV_GET_REG_VARIABLES,- sapinst_dev.log,
keydb.xml, summary.html
, KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-INS-SWPM , Installation with Software Provisioning Manager , 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.