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.
SAP Knowledge Base Article - Preview