db2 migration problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kavallin@hotmail.com - 27 Jun 2006 14:54 GMT

I recently migrated a db2 v7 to db2 v8 and it worked perfect, all
stored procs etc are there and they are executable but ... I cant edit
(through Development Center) the java stored procedures because the
source is missing ! I have tried to find the source on the old server
but I cant find it so does anyone know where the source for java stored
procedure are located ? or more correct where should they be ?
/Roger

Reply to this Message

Serge Rielau - 27 Jun 2006 15:09 GMT

> I recently migrated a db2 v7 to db2 v8 and it worked perfect, all
> stored procs etc are there and they are executable but ... I cant edit
> (through Development Center) the java stored procedures because the
> source is missing ! I have tried to find the source on the old server
> but I cant find it so does anyone know where the source for java stored
> procedure are located ? or more correct where should they be ?

To the best of my knowledge DB2 does not manage the source code for non
SQL objects. So where did YOU place the source?
Note that SQL Procedures, SQL Functions and (SQL) Triggers are
completely under DB2's control since they are SQL objects.

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ondemandbusiness/conf2006/

Reply to this Message

kavallin@hotmail.com - 27 Jun 2006 16:20 GMT

Ok Serge.. I'm aware of the above but I wasn't around when they
installed and configured the old server so I dont have any clues where
they put the source code .... and sinced I couldn't find any source
didn't I copy it to the new server....
One funny thing is that when you run Development Center and tries to
view the source , db2dc responds with this :

Getting the source from the database.
schemaname.procname - Source is not in the database.

Does that mean that should be in database some where or what ? Note
that it's possible to run the java sproc

/Roger

Reply to this Message

Serge Rielau - 27 Jun 2006 16:32 GMT

> Ok Serge.. I'm aware of the above but I wasn't around when they
> installed and configured the old server so I dont have any clues where
[quoted text clipped - 8 lines]
> Does that mean that should be in database some where or what ? Note
> that it's possible to run the java sproc

I have never used the DC with Java. The source is on the DB for SQL
Procedures.

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ondemandbusiness/conf2006/

Reply to this Message

Ian - 27 Jun 2006 20:21 GMT

> Ok Serge.. I'm aware of the above but I wasn't around when they
> installed and configured the old server so I dont have any clues where
> they put the source code .... and sinced I couldn't find any source
> didn't I copy it to the new server....

The compiled java .class files will be in ~/sqllib/function on your old
server. However, I am not 100% on whether you can just use these class
files (probably compiled with an old version of Java that may not be
compatible with V8).

As Serge suggested, DB2 does not manage source code for any external
routines. So you'll need to talk to whomever in your organization
wrote (or at least compiled) the original procedures to find out
where the java source code is.

Reply to this Message

gimme_this_gimme_that@yahoo.com - 29 Jun 2006 02:13 GMT

Look for jar files in subdirectories of SQLLIB that don't look like
they are IBM DB2 jar files and jar tvf them.

Reply to this Message