DB2: Error with routine "ALTOBJ"

Problem:

[IBM][CLI Driver][DB2/NT] SQL0443N Routine "ALTOBJ" (specific

name "") has returned an error SQLSTATE with diagnostic text

"SQL1013 Token: SR_DEV

". SQLSTATE=38553

Explanation:

• ALTOBJ is a generic error message that doesn't mean anything by itself
• The exact error cause is the string that comes after Token
• In the case above, the SR_DEV was the database name which was cataloged with the name srv_stg

Resolution:

• For the case above, I un-cataloged the database and cataloged it again with its real name SR_DEV (without using an alias)