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
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.