hi all,

i have created a database server from scratch and then restored the backup
taken from another
server. restore gets sucessfull. User is same with same set of previliges.
my database is in DB2 UDB 8.1 is on Windows 2000.

my problem is that when i try to run the procedure following error comes up

call proc_frn_link_mast();
SQL0444N Routine "*INK_MAST" (specific name "SQL041101103824671") is
implemented with code in library or path
"...qlproc\testdatabase\testuser\P0382462",
function "pgsjmp" which cannot be accessed. Reason code: "4".
SQLSTATE=42724

i tried the following after seeing the error code

CALL sqlj.replace_jar('file:c:\ora8UDFs.jar','ora8.udfjar');

it went smmothly but when i run the proc same error as above comes up again.


after this i droped the proc and then re created it and now it runs fine.

my Q's

1. do after every restore i have to drop all the procedures and recreate
them.
2. does the binding of proc & Jar is set for one time at creation or we can
refresh it.
3. i am using functions from Ora8 schema that was built from MTK, does this
mean
it requires to replace the jar file before every restore.

4. I am really confused with Jar workaround's can someone please guide me
through this.


help is highly appreciated.

regards
sachin









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