Deploying (moving to production) Java Stored Procedures

Waldo Tumanut

Deploying (moving to production) Java Stored Procedures
Would anyone share their experiences and/or procedures on deploying Java
Stored Procedures for z/OS to production subsystem? These would be stored
procedures developed using WSAD (preferebly) or Development Center.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Lance Jackson

Re: Deploying (moving to production) Java Stored Procedures
(in response to Waldo Tumanut)
Waldo,

We have been extremely successful in deployment of Java
(SQLJ) stored procedures between LPARs. The procedures were
initially developed and unit-tested on a SUN box using
Development Center; the source was migrated to a development
LPAR on the mainframe; the programs were built using a
procedure that I developed (combination of batch JCL, UNIX
scripts, etc.); the JAR files were migrated between the
development LPAR and the production LPAR using another
procedure I developed (our Change Management facility
couldn't accommodate our new application - approximately 850
Java stored procedures, so we self-installed); finally, the
migrated components (JAR files, DBRMs, BIND statements,
CREATE PROCEDURE DDL) were installed and executed on the
production LPAR. The process, although it sounds convoluted,
it really is pretty straightforward and bulletproof.

Let me know if you have any questions.

Regards,
Lance J.



---- Original message ----
>Date: Fri, 3 Dec 2004 10:43:08 -0600
>From: Waldo
Tumanut              <[login to unmask email]
NCENTURY.COM>
>Subject: Deploying (moving to production) Java Stored
Procedures
>To: [login to unmask email]
>
>Would anyone share their experiences and/or procedures on
deploying Java
>Stored Procedures for z/OS to production subsystem? These
would be stored
>procedures developed using WSAD (preferebly) or Development
Center.
>
>-------------------------------------------------------------
--------------------
>Welcome to the IDUG DB2-L list. To unsubscribe, go to the
archives and home page at http://www.idugdb2-
l.org/archives/db2-l.html. From that page select "Join or
Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-
l.org. The IDUG List Admins can be reached at DB2-L-
[login to unmask email] Find out the latest on IDUG
conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm