DB2 OS390 Java SP JARs 
Author Message
 DB2 OS390 Java SP JARs
I am very new to Java Stored Procedures in DB2 OS390 Ver 7.  I have
created one JAR for each stored procedure and used INSTALL_JAR
succesfully.  I wonder if it is best to continue to use one JAR per
SP, or if it is better to package many SP into one JAR.

I understand it may be more difficult to administer a large JAR
containing multiple SP, especially with a large development team, but
what is the impact on performance, etc?

Thanks in advance,

Tom



Mon, 21 Nov 2005 19:41:23 GMT
 DB2 OS390 Java SP JARs

We have something like 50+ Java SPs and we don't use any JAR files now.

We tried using one JAR per SP but that was just slow and silly.  Why
compress a single class into an archive?  Especially since DB2 is slow
loading JAR classes the first time around.

Then we tried using one JAR file for all our classes.  This was a tad faster
(I think because DB2 loaded the whole JAR in memory the first time around).
But I work with a large dev team, and pretty soon we started running into
problems with version control.

Now we use a separate class file for almost everything.  All you have to do
is copy the CLASS file into the FUNCTION folder of DB2.  Doing this allowed
each developer to upgrade the specific class he was working on.  This method
is also faster because now DB2 doesn't have to extract the JAR files.
Another perk is that we don't have to deal with INSTALL_JAR, REMOVE_JAR.

We're on UDB NT, you're on OS390, I realize things might be different but I
thought I'd let you know what we've discovered.


Quote:
> I am very new to Java Stored Procedures in DB2 OS390 Ver 7.  I have
> created one JAR for each stored procedure and used INSTALL_JAR
> succesfully.  I wonder if it is best to continue to use one JAR per
> SP, or if it is better to package many SP into one JAR.

> I understand it may be more difficult to administer a large JAR
> containing multiple SP, especially with a large development team, but
> what is the impact on performance, etc?

> Thanks in advance,

> Tom



Mon, 21 Nov 2005 23:33:21 GMT
 DB2 OS390 Java SP JARs
Brian,

Thanks for the great reply.  We're on OS390, you're on UDB NT, I agree
things might be different, but I will be experimenting with what
happens in z/OS (OS390) and expect we will see some similar results.

One difference is we can't place class files in a folder on the
mainframe.

It may be we will have to use IBM HPJ compiler again as we did in V 6.
 This produced a DLL type of file that was placed in a z/OS loadlib,
much like a compiled and linked C or COBOL program would have been.
This may be the equivalent of your method, not sure about that though.

Thanks,

Tom



Thu, 24 Nov 2005 00:57:12 GMT
 DB2 OS390 Java SP JARs
Tom,

Have you gotten any further on this?  We're interested in it too.

Regarding the IBM HPJ compiler, I thought that was being phased out in
future versions.  I may be all wrong on that though.

Steve

Quote:

> Brian,

> Thanks for the great reply.  We're on OS390, you're on UDB NT, I agree
> things might be different, but I will be experimenting with what
> happens in z/OS (OS390) and expect we will see some similar results.

> One difference is we can't place class files in a folder on the
> mainframe.

> It may be we will have to use IBM HPJ compiler again as we did in V 6.
>  This produced a DLL type of file that was placed in a z/OS loadlib,
> much like a compiled and linked C or COBOL program would have been.
> This may be the equivalent of your method, not sure about that though.

> Thanks,

> Tom



Sun, 27 Nov 2005 22:33:42 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. java sqlj db2connect to DB2/OS390

2. Developing IBMVA JDBC with NT DB2 driver to run on OS390 DB2 driver

3. Developing IBMVA JDBC with NT DB2 driver to run on OS390 DB2 driver

4. subscribing to os390 DB2

5. Insert into DB2 on OS390 from SQL Server 7.0 via DTS

6. Replication between SQL Server and DB2(OS390)

7. use of stored procedures DB2 V5 os390

8. Oracle to DB2 (MVS/OS390) replication

9. os390 db2 vs unix oracle

10. replicating from sybase (OS390) to db2 (AIX)

11. ? moving from Informix to DB2/OS390


 
Powered by phpBB® Forum Software