Thanks for your thoughts. We are leaning toward setting up our
environment the same as you had stated. Did you have different
conventions for your stored procedures and udf?.
Glad you asked about PDSE (partitioned dataset extended) . I had
same question. IBM strongly suggests the use of PDSE for load
(although it only mentions it for stored procedures and not udf but
assuming it applies to both). It states Using PDSE may eliminate
to stop and start the stored procedures address space due to growth
load libraries. I was surprised I would have to stop and start the
address space if the loadlib ran out of space. ? Hmmm. I imagine if
are doing lots of new additions and replacements, and you want to
risk of your library having to be extended than it may be a
set up as such. I would also be curious of anyone that has set up
udf or stored procedure loadlibs as a PDSE and if they are having
problem, and if so, what kind of problems.
I like the thought that if you use PDSE for the load library, the
extent info is dynamically updated and you do not need to stop and
the address space. If PDSs are used, load failures may occur
new extent info is not available.
American Century Services
Disclaimer: All thoughts are mine and not of my company
<[login to unmask email] To: [login to unmask email]
Subject: Re: UDF and Stored procedures in same address space?
Sent by: DB2
<[login to unmask email]
DB2 Data Base
Shan - we don't have many UDFs yet but have struggled with the same
I see this as 2 separate items -
(1) WLM environment - depends on the granularity you need (and can
I see UDFs and SPs as interchangable on a given test platform and
not to isolate the address spaces. Also, one may call the other
communication across adress spaces?
(2) Loadlib - this is more a question of application control over
migration. Are they named differently? Does someone authorized to
an SP also migrate a UDF? What about common subroutines either may
Here we started with separate loadlibs but eventually merged into 1
One related item - is everyone using PDSE's instead of PDS's for
Hope this helps.
May be this belongs in our local HOA list-serv that Jim has
[login to unmask email]
>Reply-To: DB2 Data Base Discussion List
<[login to unmask email]>
>To: [login to unmask email]
>Subject: UDF and Stored procedures in same address space?
>Date: Fri, 14 Dec 2001 10:57:41 -0600
>I'm working on a project to set up the infrastructure for using
>Defined functions. We already have the infrastructure in place
>procedures and wondered if most companies that use both, are
>WLM address space and Loadlibs , or are you trying to keep
>procedures and UDF in separate ones.
>American Century Services
>Disclaimer: All thoughts are mine and not of my company
Join the world's largest e-mail service with MSN Hotmail.