DB2 stored procedures questions

Tom - Cendant Kennedy

DB2 stored procedures questions
We are currently at DB2 v5.1 and WLM in compatibility mode. The customer
wants to start using stored procedures and is asking about having multiple
WLM-established stored procedures address spaces. In looking at the red book
Getting Started with DB2 Stored Procedures: Give Them a Call through the
Network it mentions that if you want multiple WLM-established stored
procedures address spaces you would have to start them manually, or have
some automation tool start them. My question is if you start multiple
address spaces, for example, three, how would the work be distributed? Is
that a function of the WLM by way of a service definition? Is it through
DB2? Does anybody have any experience with this?

Thanks in advance for your responses

Piontkowski Michael ML

Re: DB2 stored procedures questions
(in response to Tom - Cendant Kennedy)
WLM in compatibility mode and in goal mode assigns the work based
on WLM service definition. An added benefit of goal mode is that
WLM will start/stop the stored procedures address spaces automatically
based on servicing the WLM goals for DB2 stored procedures.



Mike Piontkowski
TP&S Technical Maintenance
Voice: +1 302.886.4612
Fax: +1 302.886.4749

-----Original Message-----
From: Kennedy, Tom - Cendant [mailto:[login to unmask email]
Sent: Thursday, December 14, 2000 15:32
To: [login to unmask email]
Subject: [DB2-L] DB2 stored procedures questions



We are currently at DB2 v5.1 and WLM in compatibility mode. The customer
wants to start using stored procedures and is asking about having multiple
WLM-established stored procedures address spaces. In looking at the red book
Getting Started with DB2 Stored Procedures: Give Them a Call through the
Network it mentions that if you want multiple WLM-established stored
procedures address spaces you would have to start them manually, or have
some automation tool start them. My question is if you start multiple
address spaces, for example, three, how would the work be distributed? Is
that a function of the WLM by way of a service definition? Is it through
DB2? Does anybody have any experience with this?

Thanks in advance for your responses

cliff boley

Re: DB2 stored procedures questions
(in response to Piontkowski Michael ML)
Tom, you set up WLM environments to start the address spaces. Then when you
create your storedprocedure (or UDF)
you assign it to one of WLM environments created. When a program calls the
SP the WLM will start the address space
for the defined environment and the SP will run in it.
BTW you must also have the RRS task installed and running to use WLM address
spaces.
have fun,
cliff:-)

-----Original Message-----
From: Kennedy, Tom - Cendant [mailto:[login to unmask email]
Sent: Thursday, December 14, 2000 12:32 PM
To: [login to unmask email]
Subject: DB2 stored procedures questions



We are currently at DB2 v5.1 and WLM in compatibility mode. The customer
wants to start using stored procedures and is asking about having multiple
WLM-established stored procedures address spaces. In looking at the red book
Getting Started with DB2 Stored Procedures: Give Them a Call through the
Network it mentions that if you want multiple WLM-established stored
procedures address spaces you would have to start them manually, or have
some automation tool start them. My question is if you start multiple
address spaces, for example, three, how would the work be distributed? Is
that a function of the WLM by way of a service definition? Is it through
DB2? Does anybody have any experience with this?

Thanks in advance for your responses



Piontkowski Michael ML

Re: DB2 stored procedures questions
(in response to cliff boley)
WLM will start/stop the address spaces in Goal Mode.
WLM will NOT start/stop the address spaces in
Compatibility Mode


Mike Piontkowski
TP&S Technical Maintenance
Voice: +1 302.886.4612
Fax: +1 302.886.4749


-----Original Message-----
From: Cliff Boley [mailto:[login to unmask email]
Sent: Thursday, December 14, 2000 19:20
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 stored procedures questions


Tom, you set up WLM environments to start the address spaces. Then when you
create your storedprocedure (or UDF)
you assign it to one of WLM environments created. When a program calls the
SP the WLM will start the address space
for the defined environment and the SP will run in it.
BTW you must also have the RRS task installed and running to use WLM address
spaces.
have fun,
cliff:-)

-----Original Message-----
From: Kennedy, Tom - Cendant [mailto:[login to unmask email]
Sent: Thursday, December 14, 2000 12:32 PM
To: [login to unmask email]
Subject: DB2 stored procedures questions



We are currently at DB2 v5.1 and WLM in compatibility mode. The customer
wants to start using stored procedures and is asking about having multiple
WLM-established stored procedures address spaces. In looking at the red book
Getting Started with DB2 Stored Procedures: Give Them a Call through the
Network it mentions that if you want multiple WLM-established stored
procedures address spaces you would have to start them manually, or have
some automation tool start them. My question is if you start multiple
address spaces, for example, three, how would the work be distributed? Is
that a function of the WLM by way of a service definition? Is it through
DB2? Does anybody have any experience with this?

Thanks in advance for your responses