hi Gurus

Background Information:

A while ago, the db2 instance home directory got filled up and corrupted
our development instance. The instance refused to start so it was dropped
and recreated. Existing development databases were intact after
re-catalog.

I didn't realize the "sqllib/jar" directory was missing until a developer
came to me with the java s/p error SQL4304N Java stored procedure or
user-defined function "...", specific name "SQL..." could not load Java
class "...", reason code "1". SQLSTATE=42724

Using Development Center, I was able to see the S/P definition but I could
not retrieve its body (the source).

Then I recreated the jar directory from a different instance (along with
the .jar files inside the folder). Within Developer Center, I was able to
highlight the S/P and click the "Build" button.
The build was successful and after that I was even able to see the body!

Problem:

I have about 40 .jar files to build so I'm wondering whether there is a
quicker (command line interface) way to rebuild the remaining S/P without
using the GUI development center, highlight each S/P and right-click the
Build button.

In addition, I have a concern on what other objects were lost during the
instance recreation.

Thanks
Ray

DB2 & UDB email list listserv db2-l LazyDBA home page