db2 migration problem

[kavallin]

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

[Serge Rielau]

ka******@hotmail.com wrote:

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
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

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

[kavallin]

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

[Serge Rielau]

ka******@hotmail.com wrote:

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

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

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

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

[Ian]

ka******@hotmail.com wrote:

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.

[gimme_this_gimme_that]

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