Setting Up WLM Stored Procedures for DB2 V7 on z/OS

[login to unmask email]

Setting Up WLM Stored Procedures for DB2 V7 on z/OS
We are in the process of finally getting started with DB2 Stored
Procedures. Up until now we have been directed not to use them. Our
environment is DB2 V7 for z/OS and z/OS V1.4, with V8 as a possibility
in 2006. All our DB2's are non-datasharing, with 4 DB2 subsystems
running on a TST lpar (the other lpars have only one DB2 system on
them).

We are starting small by looking at an application that will make a call
from a work station to execute a SP on z/OS written in either Java or
PL/I (although all indications point at Java).

I am reading the DB2 manuals and the redbook "DB2 for z/OS Stored
Procedures: Through the CALL and Beyond" to become educated on SP's and,
even though the redbook has lots of good information in it, I am
wondering how the "real world" has their environment setup for DB2 WLM
SP's.

Did you follow the redbook recommendations or did you come up with your
own?

Do you have any recommendations on security for the SP's? Again, the
redbook is a good place to start but I was wondering if this was handled
differently.

We have already completed some of the required steps, such as: RRS is
defined, WLM is in Goal Mode, SDSNLOD2 is APF authorized.

I searched the archives and found some info but it seemed a bit limited
(unless I didn't find everything). I realize this is rather generic but
I am hoping to use this to, at the very least, generate a discussion
with my co-workers so that we can determine what would work best for us.

Thanks,

Gene

This e-mail and any attachments may contain confidential information of Northwestern Mutual. If you are not the intended recipient of this message, be aware that any disclosure, copying, distribution or use of this e-mail and any attachments is prohibited. If you have received this e-mail in error, please notify Northwestern Mutual immediately by returning it to the sender and delete all copies from your system. Please be advised that communications received via the Northwestern Mutual Secure Message Center are secure. Communications that are not received via the Northwestern Mutual Secure Message Center may not be secure and could be observed by a third party. Thank you for your cooperation.


---------------------------------------------------------------------------------
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

Martin Packer

Re: Setting Up WLM Stored Procedures for DB2 V7 on z/OS
(in response to generenico@NORTHWESTERNMUTUAL.COM)
As the author of several chapters on Performance therein I can tell you I
took the "real world" and applied it when writing my bit of the book. :-)

I had a customer with a high degree of pain when using Stored Procedures
and used what we learned when thinking about their situation and talking to
them and SVL on it for the book.

Cheers, Martin

Martin Packer, MBCS CITP Martin Packer/UK/IBM
020-8832-5167 in the UK (+44) (MOBX 273643, Internal 7-325167, Mobile
07802-245584)

"Next time someone says a penny for your thoughts - sell!" Peter Kay, Hyde
Park, July 15, 2005

External Blog:
http://www-128.ibm.com/developerworks/blogs/dw_blog.jspa?blog=476
Internal Blog:
http://[login to unmask email]



Gene Renico
<[login to unmask email]
WESTERNMUTUAL.COM To
> [login to unmask email]
Sent by: DB2 Data cc
Base Discussion
List Subject
<[login to unmask email] [DB2-L] Setting Up WLM Stored
ORG> Procedures for DB2 V7 on z/OS


20/12/2005 18:46


Please respond to
DB2 Database
Discussion list
at IDUG






We are in the process of finally getting started with DB2 Stored
Procedures. Up until now we have been directed not to use them. Our
environment is DB2 V7 for z/OS and z/OS V1.4, with V8 as a possibility in
2006. All our DB2's are non-datasharing, with 4 DB2 subsystems running on
a TST lpar (the other lpars have only one DB2 system on them).

We are starting small by looking at an application that will make a call
from a work station to execute a SP on z/OS written in either Java or PL/I
(although all indications point at Java).

I am reading the DB2 manuals and the redbook "DB2 for z/OS Stored
Procedures: Through the CALL and Beyond" to become educated on SP's and,
even though the redbook has lots of good information in it, I am wondering
how the "real world" has their environment setup for DB2 WLM SP's.

Did you follow the redbook recommendations or did you come up with your
own?

Do you have any recommendations on security for the SP's? Again, the
redbook is a good place to start but I was wondering if this was handled
differently.

We have already completed some of the required steps, such as: RRS is
defined, WLM is in Goal Mode, SDSNLOD2 is APF authorized.

I searched the archives and found some info but it seemed a bit limited
(unless I didn't find everything). I realize this is rather generic but I
am hoping to use this to, at the very least, generate a discussion with my
co-workers so that we can determine what would work best for us.

Thanks,

Gene
This e-mail and any attachments may contain confidential information of
Northwestern Mutual. If you are not the intended recipient of this message,
be aware that any disclosure, copying, distribution or use of this e-mail
and any attachments is prohibited. If you have received this e-mail in
error, please notify Northwestern Mutual immediately by returning it to the
sender and delete all copies from your system. Please be advised that
communications received via the Northwestern Mutual Secure Message Center
are secure. Communications that are not received via the Northwestern
Mutual Secure Message Center may not be secure and could be observed by a
third party. Thank you for your cooperation.
---------------------------------------------------------------------------------
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

---------------------------------------------------------------------------------
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

David Churn

Re: Setting Up WLM Stored Procedures for DB2 V7 on z/OS
(in response to Martin Packer)
Gene,

If you are concerned with the performance of your Stored Procedures, then I
would avoid writing them in JAVA on the mainframe. If your other choice is
PL/I, then use it.

I attended a presentation by Peggy Zagelow on Stored Procedures. Her
comment was the fastest JAVA SP runs slower than the slower COBOL SP. I
assume the comment holds for PL/I also. The reason is the JAVA virtual
machine needs to be started. The redbook that you are reading should have
something about this topic.

Note, my company, DST Systems, is using COBOL SP on the mainframe but we do
not call them from a client.

--
David Churn
Vice-President, Heart of America DB2 Users Group


On 12/20/05, Gene Renico <[login to unmask email]> wrote:
>
> We are in the process of finally getting started with DB2 Stored
> Procedures. Up until now we have been directed not to use them. Our
> environment is DB2 V7 for z/OS and z/OS V1.4, with V8 as a possibility in
> 2006. All our DB2's are non-datasharing, with 4 DB2 subsystems running on a
> TST lpar (the other lpars have only one DB2 system on them).
>
> We are starting small by looking at an application that will make a call
> from a work station to execute a SP on z/OS written in either Java or PL/I
> (although all indications point at Java).
>
> I am reading the DB2 manuals and the redbook "DB2 for z/OS Stored
> Procedures: Through the CALL and Beyond" to become educated on SP's and,
> even though the redbook has lots of good information in it, I am wondering
> how the "real world" has their environment setup for DB2 WLM SP's.
>
> Did you follow the redbook recommendations or did you come up with your
> own?
>
> Do you have any recommendations on security for the SP's? Again, the
> redbook is a good place to start but I was wondering if this was handled
> differently.
>
> We have already completed some of the required steps, such as: RRS is
> defined, WLM is in Goal Mode, SDSNLOD2 is APF authorized.
>
> I searched the archives and found some info but it seemed a bit limited
> (unless I didn't find everything). I realize this is rather generic but I
> am hoping to use this to, at the very least, generate a discussion with my
> co-workers so that we can determine what would work best for us.
>
> Thanks,
>
> Gene
> This e-mail and any attachments may contain confidential information of
> Northwestern Mutual. If you are not the intended recipient of this message,
> be aware that any disclosure, copying, distribution or use of this e-mail
> and any attachments is prohibited. If you have received this e-mail in
> error, please notify Northwestern Mutual immediately by returning it to the
> sender and delete all copies from your system. Please be advised that
> communications received via the Northwestern Mutual Secure Message Center
> are secure. Communications that are not received via the Northwestern Mutual
> Secure Message Center may not be secure and could be observed by a third
> party. Thank you for your cooperation.
> ---------------------------------------------------------------------------------
> 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

---------------------------------------------------------------------------------
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