DB2 Control Center Error when Dropping Column

[chrisbanrhart]

Anyone have an idea why Control Center has an error referencing a table as part of a C Routine that is part of the SYSPROC Procedures? I'm attempting to drop a column that someone added erroneously and it states in order to do so, the data must be exported, table dropped and recreated, data imported, etc... Versus doing it command line, I decided to use Control Center and the following error was returned and i cant figure out how to get past.


[IBM][CLI Driver][DB2/SUN64] SQL0443N Routine "ALTOBJ" (specific
name "") has returned an error SQLSTATE with diagnostic text
"SQL0204 Token: SYSTOOLS.ALTOBJ_INFO_V
". SQLSTATE=38553


The 'Token' it is referencing is a table under the SYSTOOLS schema, but does not have the '_V' as part of the name. Not sure if that is the issue and if so, how to do I alter the ALTOBJ procedure to call the correct parameter

 

[chrisbanrhart]

Resolved: Someone removed two views that were being referenced in the ALTOBJ procedure. I created the views from source from another database and everything went smooth afterwards.