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-TLJ , Upgrade tools for Java , BC-UPG-TLS-TLA , Upgrade tools for ABAP , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.