jar cvf -C /xxx/ and then the class files

do a jar -h

once you create them you can do an sqlj.install_jar()

Look up the syntax in the application development manual








"RLam"
<db2udbdba-ezmlms
hield-x35021919.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
03/29/2006 05:37
PM Subject
SQL4304N Java stored procedure ...










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


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




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