Topic
  • No replies
Kovica
Kovica
9 Posts

Pinned topic How to revalidate procedure SQLJ.DB2_INSTALL_JAR?

‏2012-02-10T14:19:27Z |
Hi!

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?

Best regards,
Kovi