Symptom
You're upgrading Db2 and observe invalid objects in the shadow schema SAP<sid>SHD.
db2 "SELECT SUBSTR(OBJECTSCHEMA,1,20) as OBJECTSCHEMA, SUBSTR(OBJECTNAME,1,20) as OBJECTNAME, SUBSTR(ROUTINENAME,1,30) as ROUTINENAME, OBJECTTYPE, SUBSTR(ERRORMESSAGE,1,40) as ERRORMESSAGE FROM SYSCAT.INVALIDOBJECTS"
OBJECTSCHEMA OBJECTNAME ROUTINENAME OBJECTTYPE ERRORMESSAGE
SAPSIDSHD SQL220630000135242 CURRENCY_CONVERSION F SQL0204n "SAPSIDSHD.TCURX" is an undefined name.
SAPSIDSHD SQL220630000135543 CURRENCY_CONVERSION_INLINE F SQL0204n "SAPSIDSHD.TCURX" is an undefined name.
Any attempt to revalidate these objects fails with:
db2 "CALL SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS(NULL, NULL, NULL)"
SQL20482N Revalidation failed for all objects that were specified to be
revalidated. One object, "SAPSIDSHD.CURRCONV.SQL220630000135242", could not be
revalidated because it references object "SAPSIDSHD.TCURX". SQLSTATE=429C4
Read more...
Environment
- IBM DB2 LUW (DB6) any release
Product
Keywords
SQL20482N , SQL0361W , validate , upgrade , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-UPG , Upgrade SAP System , 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.