WLM Stored Procedure Address Space Management on Z/OS

Wayne Fugere

WLM Stored Procedure Address Space Management on Z/OS
I have some questions for anyone running WLM managed stored
procedures on Z/OS DB2 V7.

How did you decide how many Applenv(s) to run and how many different
procedures do you direct to a single Applenv?

Do you limit the number of address spaces per applenv or use NOLIMIT?

How do you monitor the WLM address space(s) to decide when one may be
too busy?

How do you monitor abends in the WLMs, third party tools?

Any info is appreciated.

Wayne





__________________________________
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/

---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

William Favero

Re: WLM Stored Procedure Address Space Management on Z/OS
(in response to Wayne Fugere)
What language are you writting your stored procedures in?

Wayne Fugere wrote:

>I have some questions for anyone running WLM managed stored
>procedures on Z/OS DB2 V7.
>
>How did you decide how many Applenv(s) to run and how many different
>procedures do you direct to a single Applenv?
>
>Do you limit the number of address spaces per applenv or use NOLIMIT?
>
>How do you monitor the WLM address space(s) to decide when one may be
>too busy?
>
>How do you monitor abends in the WLMs, third party tools?
>
>Any info is appreciated.
>
>Wayne
>
>
>
>
>
>__________________________________
>Do you Yahoo!?
>New Yahoo! Photos - easier uploading and sharing.
>http://photos.yahoo.com/
>
>---------------------------------------------------------------------------------
>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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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
>
>
>

--
Willie
http://www.red-corvettes.com

---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

cliff boley

Re: WLM Stored Procedure Address Space Management on Z/OS
(in response to William Favero)
Wayne,
We started with one but have added environments as the diversity of the
storedprocedrues
and users grew.

How many you create can be divided by your organizational workgroups like
you probably do for CICS and BATCH.
I've got mine broken down into four major groupings, DMV, PUC, Highway and
Tec support.
Within each group I'll have subgroups for production, development, testing
etc.
Within the subgroups I'll add WLM environments based on the type of work
being done
(finance, personal, etc.) amount of use, security, files used etc.

The rest of you question are performance related.
The number allowed, you'll need to work with your MVS systems programmer
since you'll be
creating new addresspaces.

For monitoring I guess watch the times like you would any other thread and
if the response
times get slow tweak the WLM.

cliff:-)





-----Original Message-----
From: Wayne Fugere [mailto:[login to unmask email]
Sent: Wednesday, December 10, 2003 10:28 AM
To: [login to unmask email]
Subject: WLM Stored Procedure Address Space Management on Z/OS


I have some questions for anyone running WLM managed stored
procedures on Z/OS DB2 V7.

How did you decide how many Applenv(s) to run and how many different
procedures do you direct to a single Applenv?

Do you limit the number of address spaces per applenv or use NOLIMIT?

How do you monitor the WLM address space(s) to decide when one may be
too busy?

How do you monitor abends in the WLMs, third party tools?

Any info is appreciated.

Wayne





__________________________________
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/

----------------------------------------------------------------------------
-----
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". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] 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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

Avram Friedman

Re: WLM Stored Procedure Address Space Management on Z/OS
(in response to cliff boley)
We feel the correct number of application environments is a compromise between 1 and infinity.

I tend to personally support numbers closer to 1. If there are no changing DD's between one application environment and another then the extra application environment is most likely not needed. The one exception to this rule is if a special WLM is maintained for staging, burnin, diagnostics etc. Two popular applications that require special PROCS and thus special WLM environments are the Stored Procedure Builder and JAVA.

We generally frown on any user datasets being present in WLM procs either hard coded or dynamic.

We let the WLM control the number of WLM address spaces active at any moment in time.

The same diagnostic techniques that work for non WLM stored procedure address spaces work for WLM stored procedure address spaces.

Some application planning tips
1. Consistent RUNOPS (any change invalidates residency)
2. Reentrant if possible
3. No application (non DB2) I/O



Wayne Fugere wrote:

> I have some questions for anyone running WLM managed stored
> procedures on Z/OS DB2 V7.
>
> How did you decide how many Applenv(s) to run and how many different
> procedures do you direct to a single Applenv?
>
> Do you limit the number of address spaces per applenv or use NOLIMIT?
>
> How do you monitor the WLM address space(s) to decide when one may be
> too busy?
>
> How do you monitor abends in the WLMs, third party tools?
>
> Any info is appreciated.
>
> Wayne
>
> __________________________________
> Do you Yahoo!?
> New Yahoo! Photos - easier uploading and sharing.
> http://photos.yahoo.com/
>
> ---------------------------------------------------------------------------------
> 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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

--
NOTICE: If received in error, please destroy and notify sender. Sender does not waive confidentiality or privilege, and use is prohibited.

---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

Aurora Dellanno

Re: WLM Stored Procedure Address Space Management on Z/OS
(in response to Avram Friedman)
Wayne,

Apart from all the illuminated answers that you have had (and no doubt will
have) from my betters (no longer elders at my age ;-) I can offer you some
good white papers and presentations. If you wish, I can email them to you.

ciao!

Aurora Emanuela Dell'Anno
Database Analyst
Data Services Group - Bank of America
tel. 66192
ext. 0208 760 6192
[login to unmask email]

* std. disclaimer * MY OPINIONS ARE MY OWN AND NOT THOSE OF MY EMPLOYER

no trees were killed in sending this message. However, a large number of
electrons were seriously inconvenienced :-)



-----Original Message-----
From: Wayne Fugere [mailto:[login to unmask email]
Sent: 10 December 2003 18:28
To: [login to unmask email]
Subject: WLM Stored Procedure Address Space Management on Z/OS


I have some questions for anyone running WLM managed stored
procedures on Z/OS DB2 V7.

How did you decide how many Applenv(s) to run and how many different
procedures do you direct to a single Applenv?

Do you limit the number of address spaces per applenv or use NOLIMIT?

How do you monitor the WLM address space(s) to decide when one may be
too busy?

How do you monitor abends in the WLMs, third party tools?

Any info is appreciated.

Wayne





__________________________________
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/

----------------------------------------------------------------------------
-----
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". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] 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

Notice to recipient:
The information in this internet e-mail and any attachments is confidential
and may be privileged. It is intended solely for the addressee. If you are
not the intended addressee please notify the sender immediately by
telephone. If you are not the intended recipient, any disclosure, copying,
distribution or any action taken or omitted to be taken in reliance on it,
is prohibited and may be unlawful.
When addressed to external clients any opinions or advice contained in this
internet e-mail are subject to the terms and conditions expressed in any
applicable governing terms of business or client engagement letter issued by
the pertinent Bank of America group entity.
If this email originates from the U.K. please note that Bank of America,
N.A., London Branch, Banc of America Securities Limited and Banc of America
Futures Incorporated are regulated by the Financial Services Authority.

---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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