converting SPAS to WLM - thoughts?

Chris Hoelscher

converting SPAS to WLM - thoughts?
we are currently on DB2 7.x - in preparation for migration to release 8,
we are moving from an SPAS address space to WLM address space(s) for
stored procedures
I have recommendations from IBM and my own thoughts on how to split up the
existing SPs into WLM environments, but I hope never to be too arrogant to
not to ask for (or refuse) advise from others - generally - what criteria
have others used to set up the WLM environments?

JAVA vs SQL?
Build vs Execute?
Appl 'A' vs Appl 'B'?
frequency of execution?
resources consumed by execution?
none of the above?
other considerations

thanks in advance,
Chris Hoelscher
IDMS & DB2 Database Administrator
Humana Inc
502-580-2538
[login to unmask email]




The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.

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

[login to unmask email]

Re: converting SPAS to WLM - thoughts?
(in response to Chris Hoelscher)
Chris,

There are several different ways of support WLM-managed stored procedures.
A lot depends on the numbers of SPs that you support, how CPU- and
I/O-intensive they are, and how confident you are that they are written
well :)

For what it's worth, here is what I have always recommended -- you can
start with this as a base, and customize from there. ("# Appl Env" is the
number of defined WLM Application Environments.)

# Appl Env Usage

1 Miscellaneous DB2-supplied SPs used by Development Center
1 DSNTPSMP and DSNTBIND (DB2-supplied REXX)
with NUMTCB=1
1 Debugging with Debug Tool
1 Java-related Stored Procedures
with NUMTCB <= 8
1 - n "Normal" SQL, Cobol, C/C++, PL/1-related Stored Procedures
1 - m Same as above, but reserveded for "possibly poor-performing"
Stored Procedures, or for those assigned a Low priority

Set up these AEs in WLM, assign them goals based on how your shop does it.

There's tons more information in the various stored procedure RedBooks.

Hope this helps!

Lock Lyon
Compuware Corp




Chris Hoelscher <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
01/05/2006 09:19 AM
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email]
cc

Subject
[DB2-L] converting SPAS to WLM - thoughts?







we are currently on DB2 7.x - in preparation for migration to release 8,
we are moving from an SPAS address space to WLM address space(s) for
stored procedures
I have recommendations from IBM and my own thoughts on how to split up the
existing SPs into WLM environments, but I hope never to be too arrogant to
not to ask for (or refuse) advise from others - generally - what criteria
have others used to set up the WLM environments?

JAVA vs SQL?
Build vs Execute?
Appl 'A' vs Appl 'B'?
frequency of execution?
resources consumed by execution?
none of the above?
other considerations

thanks in advance,
Chris Hoelscher
IDMS & DB2 Database Administrator
Humana Inc
502-580-2538
[login to unmask email]


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

Philip Gunning

Re: converting SPAS to WLM - thoughts?
(in response to LL581@DAIMLERCHRYSLER.COM)
Chris, The Administration Guide has some good recommendations and there is a
Workload Management manual that will describe how to setup WLM. Also, some
old redbook that will help to describe the WLM concept. Of course some
things have changed with V8. Cheers, Phil









< http://www.gunningts.com/db2zone.htm > www.gunningts.com/db2zone.htm

610.451.5801 Fax 514-509-6886

"We help people succeed with DB2"

ITgain:http://www.itgain.de

AIM: db2luw

GET READY TO RELEASE THE VIPER
AT:http://www-306.ibm.com/software/data/db2/udb/viper/

_____

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Chris Hoelscher
Sent: Thursday, January 05, 2006 9:20 AM
To: [login to unmask email]
Subject: [DB2-L] converting SPAS to WLM - thoughts?




we are currently on DB2 7.x - in preparation for migration to release 8, we
are moving from an SPAS address space to WLM address space(s) for stored
procedures
I have recommendations from IBM and my own thoughts on how to split up the
existing SPs into WLM environments, but I hope never to be too arrogant to
not to ask for (or refuse) advise from others - generally - what criteria
have others used to set up the WLM environments?

JAVA vs SQL?
Build vs Execute?
Appl 'A' vs Appl 'B'?
frequency of execution?
resources consumed by execution?
none of the above?
other considerations

thanks in advance,
Chris Hoelscher
IDMS & DB2 Database Administrator
Humana Inc
502-580-2538
[login to unmask email]



The information transmitted is intended only for the person or entity to
which it is addressed and may contain CONFIDENTIAL material. If you receive
this material/information in error, please contact the sender and delete or
destroy the material/information.
----------------------------------------------------------------------------
----- 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