I'm running Express-C 9.7.5 on Ubuntu 11.10.
After creating, altering my objects (tables, views, sequences, ...) in a database I found out that procedure SQLJ.DB2_INSTALL_JAR is invalid. Actually there are a number of procedures in SQLJ schema invalid.
I've run "CALL SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS()" to revalidate all database objects, but the SQLJ procedures still remain invalid.
Procedure SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS did run OK, no errors or warnings were reported.
How can I revalidate them to make them valid again?
This topic has been locked.