WLM STORE PROCEDURE QUESTION

Miguel Del Valle Martinez

WLM STORE PROCEDURE QUESTION
Doe anybody knows if I can run a store procedure in multiples WLM and I
so could you help me with the sysntax

For the WLM ENVIROMENT keyword definition.



The problem is that I have a sharing system with 4 DB2 two in one lpar
and 2 in a second lpar. When I run the store

Procedure sometimes thw Z/OS wlm send the store procedure to a subsystem
that is no define in the WLM ENVIROMENT

Definition because I can only define 1 susystem in which the store
procedure runs.



Any helps



Regard



miguel




______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

James Campbell

Re: WLM STORE PROCEDURE QUESTION
(in response to Miguel Del Valle Martinez)
In the WLM Application Environment definition, use DB2SSID=&IWMSSNM.
The WLM AE must be defined in both LPARs

In the WLM JCL, use &DB2SSID for the subsystem name.

James Campbell

On 2 Dec 2008 at 15:19, Miguel Del Valle Martinez wrote:

>
> Doe anybody knows if I can run a store procedure in multiples WLM and I so could you help me
> with the sysntax
> For the WLM ENVIROMENT keyword definition.
>
> The problem is that I have a sharing system with 4 DB2 two in one lpar and 2 in a second lpar.
> When I run the store
> Procedure sometimes thw Z/OS wlm send the store procedure to a subsystem that is no define in
> the WLM ENVIROMENT
> Definition because I can only define 1 susystem in which the store procedure runs.
>
> Any helps
>
> Regard
>
> miguel
>

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Douwe van Sluis

Re: WLM STORE PROCEDURE QUESTION
(in response to James Campbell)
Miguel,

You need to use the parm &IWMSSNM.
In your WLM AE definition use something like:
Appl Environment Name . . <AE-name>

Description . . . . . . . <description>

Subsystem type . . . . . DB2

Procedure name . . . . . <PROC-name>

Start parameters . . . . APPLENV=<AE-name>,DB2SSID=&IWMSSNM,JOBNAM


E=&IWMSSNM.<some name>

And in the STC JCL for the WLM AE:

//<some> PROC RGN=0K,APPLENV=XXXXXXXX,DB2SSID=XXXX,NUMTCB=<numtcb>

//IEFPROC EXEC PGM=DSNX9WLM,REGION=&RGN,TIME=NOLIMIT,

// PARM='&DB2SSID,&NUMTCB,&APPLENV'


What the above does is the following:
It uses the parm &IWMSSNM to substitute the DB2 member that wants to
start the WLM AE. In the PARM field of the EXEC the right DB2 member is
used. The jobname will also contain the DB2 membername that started the
WLM AE.
Note that is may come in handy to have the NUMTCB in the STC JCL and
outside the WLM AE definition. JCL is easier to change.

Hope this helps.

Vriendelijke groet,
Douwe van Sluis


-----Oorspronkelijk bericht-----
Van: DB2 Data Base Discussion List [mailto:[login to unmask email] Namens
Miguel Del Valle Martinez
Verzonden: dinsdag 2 december 2008 20:20
Aan: [login to unmask email]
Onderwerp: [DB2-L] WLM STORE PROCEDURE QUESTION



Doe anybody knows if I can run a store procedure in multiples WLM and I
so could you help me with the sysntax

For the WLM ENVIROMENT keyword definition.



The problem is that I have a sharing system with 4 DB2 two in one lpar
and 2 in a second lpar. When I run the store

Procedure sometimes thw Z/OS wlm send the store procedure to a subsystem
that is no define in the WLM ENVIROMENT

Definition because I can only define 1 susystem in which the store
procedure runs.



Any helps



Regard



miguel



_____




CONFIDENTIALITY NOTE: This email communication and its attachments
contain information that are proprietary and confidential to EVERTEC,
INC., its affiliates or its clients. They may not be disclosed,
distributed, used, copied or modified in any way without EVERTEC, Inc.'s
authorization. If you are not the intended recipient of this email, you
are not an authorized person. Please delete it and notify the sender
immediately. EVERTEC, Inc. and its affiliates do not assume any
liability for damages resulting from emails that have been sent or
altered without their consent. Moreover, EVERTEC, Inc. has taken
precautions to safeguard its email communications, but cannot assure
that such is the case and disclaim any responsibility attributable
thereto.


_____

< http://idug.org/lsNA > IDUG 2009 - North America * May 11-15, 2009 *
Denver, CO, USA

The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, FAQ, and delivery preferences are at IDUG.ORG
< http://www.idug.org/lsidug > under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > , and much more. If you have not yet signed
up for Basic Membership in IDUG, available at no cost, click on Member
< http://www.idug.org/lsms > Services


______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Miguel Del Valle Martinez

Re: WLM STORE PROCEDURE QUESTION
(in response to Douwe van Sluis)
What about the store procedure definition

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of James Campbell
Sent: Tuesday, December 02, 2008 5:19 PM
To: [login to unmask email]
Subject: Re: [DB2-L] WLM STORE PROCEDURE QUESTION

In the WLM Application Environment definition, use DB2SSID=&IWMSSNM.
The WLM AE must be defined in both LPARs

In the WLM JCL, use &DB2SSID for the subsystem name.

James Campbell

On 2 Dec 2008 at 15:19, Miguel Del Valle Martinez wrote:

>
> Doe anybody knows if I can run a store procedure in multiples WLM and
I so could you help me
> with the sysntax
> For the WLM ENVIROMENT keyword definition.
>
> The problem is that I have a sharing system with 4 DB2 two in one lpar
and 2 in a second lpar.
> When I run the store
> Procedure sometimes thw Z/OS wlm send the store procedure to a
subsystem that is no define in
> the WLM ENVIROMENT
> Definition because I can only define 1 susystem in which the store
procedure runs.
>
> Any helps
>
> Regard
>
> miguel
>

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services at http://www.idug.org/lsms

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Douwe van Sluis

Re: WLM STORE PROCEDURE QUESTION
(in response to Miguel Del Valle Martinez)
Depends on how your Z-system programmers have set-up WLM.
If you are on a sysplex, than they should have set-up 1 WLM Environment
for all lpars in the plex.

Your WLM AE is what you define in the Stored Procedure. This WLM AE
should be the same for every LPAR and DB2 member.

With the technique we suggested, it does not matter to which DB2 member
WLM sends the workload.

So to have the overview:
1) Set up your Stored Procedure in the DDL you define the WLM AE you
want to use.
2) Define a WLM AE with the same name as used in 1.
3) Make sure that this WLM AE is available on all lpars in the plex.
4) Use at least a parameter like DB2SSID=&IWMSSNM.
5) The Procedure name should name a STC JCL that is set-up without hard
coded DB2 member names.
6) Use the parameter defined in the WLM AE in your STC JCL, in this
example PARM='&DB2SSID, ....'
7) The whole set-up also need appropriate RACF definitions.

Also have a look at Redbook SG24-7604, a great deal of what we described
is in there.

Vriendelijke groet,
Douwe van Sluis




-----Oorspronkelijk bericht-----
Van: DB2 Data Base Discussion List [mailto:[login to unmask email] Namens
Miguel Del Valle Martinez
Verzonden: dinsdag 2 december 2008 22:57
Aan: [login to unmask email]
Onderwerp: Re: [DB2-L] WLM STORE PROCEDURE QUESTION


What about the store procedure definition

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of James Campbell
Sent: Tuesday, December 02, 2008 5:19 PM
To: [login to unmask email]
Subject: Re: [DB2-L] WLM STORE PROCEDURE QUESTION

In the WLM Application Environment definition, use DB2SSID=&IWMSSNM.
The WLM AE must be defined in both LPARs

In the WLM JCL, use &DB2SSID for the subsystem name.

James Campbell

On 2 Dec 2008 at 15:19, Miguel Del Valle Martinez wrote:

>
> Doe anybody knows if I can run a store procedure in multiples WLM and
I so could you help me
> with the sysntax
> For the WLM ENVIROMENT keyword definition.
>
> The problem is that I have a sharing system with 4 DB2 two in one lpar
and 2 in a second lpar.
> When I run the store
> Procedure sometimes thw Z/OS wlm send the store procedure to a
subsystem that is no define in
> the WLM ENVIROMENT
> Definition because I can only define 1 susystem in which the store
procedure runs.
>
> Any helps
>
> Regard
>
> miguel
>

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information and much more. If
you have not yet signed up for Basic Membership in IDUG, available at no
cost, click on Member Services at http://www.idug.org/lsms

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services at http://www.idug.org/lsms

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Miguel Del Valle Martinez

Re: WLM STORE PROCEDURE QUESTION
(in response to Douwe van Sluis)
Can you specified in WLM ENVIRONMENT THE data sharing group name
otherwise I will be point in the store procedure to a ssn that is no
define in the second lpar. I have t1g2,t3g2 (LPAR #1), T2G2,T4G2
(LPAR#2)


THE STORE PROCEDURE HAVE WLM-ENVIRONMENT T1G2WLM

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Douwe van Sluis
Sent: Wednesday, December 03, 2008 3:15 AM
To: [login to unmask email]
Subject: Re: [DB2-L] WLM STORE PROCEDURE QUESTION

Depends on how your Z-system programmers have set-up WLM.
If you are on a sysplex, than they should have set-up 1 WLM Environment
for all lpars in the plex.

Your WLM AE is what you define in the Stored Procedure. This WLM AE
should be the same for every LPAR and DB2 member.

With the technique we suggested, it does not matter to which DB2 member
WLM sends the workload.

So to have the overview:
1) Set up your Stored Procedure in the DDL you define the WLM AE you
want to use.
2) Define a WLM AE with the same name as used in 1.
3) Make sure that this WLM AE is available on all lpars in the plex.
4) Use at least a parameter like DB2SSID=&IWMSSNM.
5) The Procedure name should name a STC JCL that is set-up without hard
coded DB2 member names.
6) Use the parameter defined in the WLM AE in your STC JCL, in this
example PARM='&DB2SSID, ....'
7) The whole set-up also need appropriate RACF definitions.

Also have a look at Redbook SG24-7604, a great deal of what we described
is in there.

Vriendelijke groet,
Douwe van Sluis




-----Oorspronkelijk bericht-----
Van: DB2 Data Base Discussion List [mailto:[login to unmask email] Namens
Miguel Del Valle Martinez
Verzonden: dinsdag 2 december 2008 22:57
Aan: [login to unmask email]
Onderwerp: Re: [DB2-L] WLM STORE PROCEDURE QUESTION


What about the store procedure definition

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of James Campbell
Sent: Tuesday, December 02, 2008 5:19 PM
To: [login to unmask email]
Subject: Re: [DB2-L] WLM STORE PROCEDURE QUESTION

In the WLM Application Environment definition, use DB2SSID=&IWMSSNM.
The WLM AE must be defined in both LPARs

In the WLM JCL, use &DB2SSID for the subsystem name.

James Campbell

On 2 Dec 2008 at 15:19, Miguel Del Valle Martinez wrote:

>
> Doe anybody knows if I can run a store procedure in multiples WLM and
I so could you help me
> with the sysntax
> For the WLM ENVIROMENT keyword definition.
>
> The problem is that I have a sharing system with 4 DB2 two in one lpar
and 2 in a second lpar.
> When I run the store
> Procedure sometimes thw Z/OS wlm send the store procedure to a
subsystem that is no define in
> the WLM ENVIROMENT
> Definition because I can only define 1 susystem in which the store
procedure runs.
>
> Any helps
>
> Regard
>
> miguel
>

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information and much more. If
you have not yet signed up for Basic Membership in IDUG, available at no
cost, click on Member Services at http://www.idug.org/lsms

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services at http://www.idug.org/lsms

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services at http://www.idug.org/lsms

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Douwe van Sluis

Re: WLM STORE PROCEDURE QUESTION
(in response to Miguel Del Valle Martinez)
Looks like a naming convention problem to me.
Don't use your DB2 member name in the WLM AE.
From a DB2 point of view a WLM AE is on the DB2 Group level.
You can only define a SP ones in a DB2 Catalog and a DB2 Catalog belongs
to a DB2 Group.

So you need a new naming convention for your WLM AE.
For instance G2WLM.

Vriendelijke groet,
Douwe van Sluis




-----Oorspronkelijk bericht-----
Van: DB2 Data Base Discussion List [mailto:[login to unmask email] Namens
Miguel Del Valle Martinez
Verzonden: woensdag 3 december 2008 18:06
Aan: [login to unmask email]
Onderwerp: Re: [DB2-L] WLM STORE PROCEDURE QUESTION


Can you specified in WLM ENVIRONMENT THE data sharing group name
otherwise I will be point in the store procedure to a ssn that is no
define in the second lpar. I have t1g2,t3g2 (LPAR #1), T2G2,T4G2
(LPAR#2)


THE STORE PROCEDURE HAVE WLM-ENVIRONMENT T1G2WLM

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Douwe van Sluis
Sent: Wednesday, December 03, 2008 3:15 AM
To: [login to unmask email]
Subject: Re: [DB2-L] WLM STORE PROCEDURE QUESTION

Depends on how your Z-system programmers have set-up WLM.
If you are on a sysplex, than they should have set-up 1 WLM Environment
for all lpars in the plex.

Your WLM AE is what you define in the Stored Procedure. This WLM AE
should be the same for every LPAR and DB2 member.

With the technique we suggested, it does not matter to which DB2 member
WLM sends the workload.

So to have the overview:
1) Set up your Stored Procedure in the DDL you define the WLM AE you
want to use.
2) Define a WLM AE with the same name as used in 1.
3) Make sure that this WLM AE is available on all lpars in the plex.
4) Use at least a parameter like DB2SSID=&IWMSSNM.
5) The Procedure name should name a STC JCL that is set-up without hard
coded DB2 member names.
6) Use the parameter defined in the WLM AE in your STC JCL, in this
example PARM='&DB2SSID, ....'
7) The whole set-up also need appropriate RACF definitions.

Also have a look at Redbook SG24-7604, a great deal of what we described
is in there.

Vriendelijke groet,
Douwe van Sluis




-----Oorspronkelijk bericht-----
Van: DB2 Data Base Discussion List [mailto:[login to unmask email] Namens
Miguel Del Valle Martinez
Verzonden: dinsdag 2 december 2008 22:57
Aan: [login to unmask email]
Onderwerp: Re: [DB2-L] WLM STORE PROCEDURE QUESTION


What about the store procedure definition

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of James Campbell
Sent: Tuesday, December 02, 2008 5:19 PM
To: [login to unmask email]
Subject: Re: [DB2-L] WLM STORE PROCEDURE QUESTION

In the WLM Application Environment definition, use DB2SSID=&IWMSSNM.
The WLM AE must be defined in both LPARs

In the WLM JCL, use &DB2SSID for the subsystem name.

James Campbell

On 2 Dec 2008 at 15:19, Miguel Del Valle Martinez wrote:

>
> Doe anybody knows if I can run a store procedure in multiples WLM and
I so could you help me
> with the sysntax
> For the WLM ENVIROMENT keyword definition.
>
> The problem is that I have a sharing system with 4 DB2 two in one lpar
and 2 in a second lpar.
> When I run the store
> Procedure sometimes thw Z/OS wlm send the store procedure to a
subsystem that is no define in
> the WLM ENVIROMENT
> Definition because I can only define 1 susystem in which the store
procedure runs.
>
> Any helps
>
> Regard
>
> miguel
>

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information and much more. If
you have not yet signed up for Basic Membership in IDUG, available at no
cost, click on Member Services at http://www.idug.org/lsms

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information and much more. If
you have not yet signed up for Basic Membership in IDUG, available at no
cost, click on Member Services at http://www.idug.org/lsms

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information and much more. If
you have not yet signed up for Basic Membership in IDUG, available at no
cost, click on Member Services at http://www.idug.org/lsms

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services at http://www.idug.org/lsms

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Miguel Del Valle Martinez

Re: WLM STORE PROCEDURE QUESTION
(in response to Douwe van Sluis)
Thanks I understand.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Douwe van Sluis
Sent: Wednesday, December 03, 2008 3:48 PM
To: [login to unmask email]
Subject: Re: [DB2-L] WLM STORE PROCEDURE QUESTION

Looks like a naming convention problem to me.
Don't use your DB2 member name in the WLM AE.
From a DB2 point of view a WLM AE is on the DB2 Group level.
You can only define a SP ones in a DB2 Catalog and a DB2 Catalog belongs
to a DB2 Group.

So you need a new naming convention for your WLM AE.
For instance G2WLM.

Vriendelijke groet,
Douwe van Sluis




-----Oorspronkelijk bericht-----
Van: DB2 Data Base Discussion List [mailto:[login to unmask email] Namens
Miguel Del Valle Martinez
Verzonden: woensdag 3 december 2008 18:06
Aan: [login to unmask email]
Onderwerp: Re: [DB2-L] WLM STORE PROCEDURE QUESTION


Can you specified in WLM ENVIRONMENT THE data sharing group name
otherwise I will be point in the store procedure to a ssn that is no
define in the second lpar. I have t1g2,t3g2 (LPAR #1), T2G2,T4G2
(LPAR#2)


THE STORE PROCEDURE HAVE WLM-ENVIRONMENT T1G2WLM

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Douwe van Sluis
Sent: Wednesday, December 03, 2008 3:15 AM
To: [login to unmask email]
Subject: Re: [DB2-L] WLM STORE PROCEDURE QUESTION

Depends on how your Z-system programmers have set-up WLM.
If you are on a sysplex, than they should have set-up 1 WLM Environment
for all lpars in the plex.

Your WLM AE is what you define in the Stored Procedure. This WLM AE
should be the same for every LPAR and DB2 member.

With the technique we suggested, it does not matter to which DB2 member
WLM sends the workload.

So to have the overview:
1) Set up your Stored Procedure in the DDL you define the WLM AE you
want to use.
2) Define a WLM AE with the same name as used in 1.
3) Make sure that this WLM AE is available on all lpars in the plex.
4) Use at least a parameter like DB2SSID=&IWMSSNM.
5) The Procedure name should name a STC JCL that is set-up without hard
coded DB2 member names.
6) Use the parameter defined in the WLM AE in your STC JCL, in this
example PARM='&DB2SSID, ....'
7) The whole set-up also need appropriate RACF definitions.

Also have a look at Redbook SG24-7604, a great deal of what we described
is in there.

Vriendelijke groet,
Douwe van Sluis




-----Oorspronkelijk bericht-----
Van: DB2 Data Base Discussion List [mailto:[login to unmask email] Namens
Miguel Del Valle Martinez
Verzonden: dinsdag 2 december 2008 22:57
Aan: [login to unmask email]
Onderwerp: Re: [DB2-L] WLM STORE PROCEDURE QUESTION


What about the store procedure definition

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of James Campbell
Sent: Tuesday, December 02, 2008 5:19 PM
To: [login to unmask email]
Subject: Re: [DB2-L] WLM STORE PROCEDURE QUESTION

In the WLM Application Environment definition, use DB2SSID=&IWMSSNM.
The WLM AE must be defined in both LPARs

In the WLM JCL, use &DB2SSID for the subsystem name.

James Campbell

On 2 Dec 2008 at 15:19, Miguel Del Valle Martinez wrote:

>
> Doe anybody knows if I can run a store procedure in multiples WLM and
I so could you help me
> with the sysntax
> For the WLM ENVIROMENT keyword definition.
>
> The problem is that I have a sharing system with 4 DB2 two in one lpar
and 2 in a second lpar.
> When I run the store
> Procedure sometimes thw Z/OS wlm send the store procedure to a
subsystem that is no define in
> the WLM ENVIROMENT
> Definition because I can only define 1 susystem in which the store
procedure runs.
>
> Any helps
>
> Regard
>
> miguel
>

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information and much more. If
you have not yet signed up for Basic Membership in IDUG, available at no
cost, click on Member Services at http://www.idug.org/lsms

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information and much more. If
you have not yet signed up for Basic Membership in IDUG, available at no
cost, click on Member Services at http://www.idug.org/lsms

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information and much more. If
you have not yet signed up for Basic Membership in IDUG, available at no
cost, click on Member Services at http://www.idug.org/lsms

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services at http://www.idug.org/lsms

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services at http://www.idug.org/lsms

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

David Barry

Re: WLM STORE PROCEDURE QUESTION
(in response to Miguel Del Valle Martinez)
Sounds like you may need to use dynamic subsystem name in WLM application environment definition. Instead of naming the subsystem, try using the special symbol &IWMSSNM.

Start parameters . . . . DB2SSN=&IWMSSNM

________________________________
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Miguel Del Valle Martinez
Sent: Tuesday, December 02, 2008 2:20 PM
To: [login to unmask email]
Subject: [DB2-L] WLM STORE PROCEDURE QUESTION

Doe anybody knows if I can run a store procedure in multiples WLM and I so could you help me with the sysntax
For the WLM ENVIROMENT keyword definition.

The problem is that I have a sharing system with 4 DB2 two in one lpar and 2 in a second lpar. When I run the store
Procedure sometimes thw Z/OS wlm send the store procedure to a subsystem that is no define in the WLM ENVIROMENT
Definition because I can only define 1 susystem in which the store procedure runs.

Any helps

Regard

miguel

________________________________

CONFIDENTIALITY NOTE: This email communication and its attachments contain information that are proprietary and confidential to EVERTEC, INC., its affiliates or its clients. They may not be disclosed, distributed, used, copied or modified in any way without EVERTEC, Inc.'s authorization. If you are not the intended recipient of this email, you are not an authorized person. Please delete it and notify the sender immediately. EVERTEC, Inc. and its affiliates do not assume any liability for damages resulting from emails that have been sent or altered without their consent. Moreover, EVERTEC, Inc. has taken precautions to safeguard its email communications, but cannot assure that such is the case and disclaim any responsibility attributable thereto.

________________________________

IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA < http://idug.org/lsNA >

The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at IDUG.ORG <http://www.idug.org/lsidug> under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information<http://www.idug.org/lsconf>, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services< http://www.idug.org/lsms >

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms