If you do a restore and you have created jar files in the old data base
you will need to copy the jar files from the old location to the
new location /sqllib/function/ (or wherever you put them). Once you move
them there you can do the replace_jar.
As for the stored procedures, they should appear if you have INDEXREC =
ACCESS or RESTART. Sometimes the stored procedures
need rebinding if they are built again. Once you do your connect or
activate on the database, check to see if the executable is there
in the file system specfied below.
Once you get to version 8.2, that stored procedure issue will go away as
there are no executables, only byte code in the catalog.
Dan Callahan IT Specialist
603-472-4121 t/l 525-4121
[Email address protected]
[Email address protected]
"Sachin Kumar "
<db2udbdba-ezmlms
hield-x88840820.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
12/28/2004 09:19
AM Subject
DB2 - Jar Help required
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
---------------------------------------------------------------------
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