SAP Knowledge Base Article - Preview

2790867 - SAP upgrade reports -204 on Db2 table SYSIBM.DSN_PROFILE_TABLE

Symptom

During upgrade phase PREP_INPUT/DBQUERY_PRE SAPup reports the following -204 error in log file DB2GRASH.LOG:

===========================================================================================

DB2 Call 'SQLExecDirectW' Error: conHdl = 00 SQLCODE = -204 : [IBM][CLI Driver][DB2] SYSIBM.DSN_PROFILE_TABLE IS AN UNDEFINED NAME
DB2Trc: GRANT SELECT ON TABLE SYSIBM.DSN_PROFILE_TABLE TO SAPSID;
DbSl Execute returned with rc = 103:
meaning: table/view doesn't exist.
[IBM][CLI Driver][DB2] SYSIBM.DSN_PROFILE_TABLE IS AN UNDEFINED NAME

ERROR: GRANT statement "GRANT SELECT ON TABLE SYSIBM.DSN_PROFILE_TABLE TO SAPSID" failed (-1)
COMMIT WORK successfully executed .

Disconnecting from database

DB2RADM EXITCODE: 12
db2radm finished (0012)
[INFO] [20190508063804][End] Return Code is: 12
=======================================================================================


The Software Update Manager (SUM) reports the following:

=======================================================================================
Current Phase: PREP_INPUT/DBQUERY_PRE

Severe error(s) occurred in phase PREP_INPUT/DBQUERY_PRE !

Last error code set:
Grant of privileges for shadow schema SAPSID failed. For details refer to the log files:
    /SUM/abap/log/DB2GRASH.LOG
    /SUM/abap/log/DB2RADM.LOG

Trouble Ticket Generation
=======================================================================================


Read more...

Environment

  • Db2 z/OS V10 or newer
  • Software Update Manager (SUM) releases using a Kernel supplied with a newer release of the 'db2radm' tool

Product

SAP ERP 6.0 ; SAP NetWeaver all versions ; software logistics toolset 1.0

Keywords

SQL0204N SUM SPAM z/OS UDB SAPup.exe Extraction Bind , KBA , BC-DB-DB2 , DB2 for z/OS , BC-UPG-TLS-TLA , Upgrade tools for ABAP , BC-UPG-TLS-TLJ , Upgrade tools for Java , 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.