[DB2v9 z/OS] Native SQL SP invocation

Philip Sevetson

[DB2v9 z/OS] Native SQL SP invocation
Does anyone know off hand where native SQL Stored Procs run in DB2V9?
DBM1, or WLM?



--Phil Sevetson, NYCAPS DBA Support

Financial Information Services Agency of The City of New York

450 West 33rd Street, 4th Floor

New York, NY 10001

phone: (212) 857-1688

mailto: [login to unmask email] <mailto:[login to unmask email]>





=========
Confidentiality Notice: This e-mail communication, and any attachments, contains confidential and privileged information for the exclusive use of the recipient(s) named above. If you are not an intended recipient, or the employee or agent responsible to deliver it to an intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify me immediately by replying to this message and delete this communication from your computer. Thank you.

Any opinions, expressed or implied, presented are solely those of the author and do not necessarily represent the opinions of the agency or the City.
=========




______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

M. Khalid Khan

Re: [DB2v9 z/OS] Native SQL SP invocation
(in response to Philip Sevetson)
In DBM1.




"Sevetson, Phil" <[login to unmask email]>
Sent by: "DB2 Data Base Discussion List" <[login to unmask email]>
01/12/2009 10:55 AM
Please respond to
"DB2 Database Discussion list at IDUG" <[login to unmask email]>


To
[login to unmask email]
cc

Subject
[DB2-L] [DB2v9 z/OS] Native SQL SP invocation






Does anyone know off hand where native SQL Stored Procs run in DB2V9?
DBM1, or WLM?

--Phil Sevetson, NYCAPS DBA Support
Financial Information Services Agency of The City of New York
450 West 33rd Street, 4th Floor
New York, NY 10001
phone: (212) 857-1688
mailto: [login to unmask email]

=========
Confidentiality Notice: This e-mail communication, and any attachments,
contains confidential and privileged information for the exclusive use of
the recipient(s) named above. If you are not an intended recipient, or the
employee or agent responsible to deliver it to an intended recipient, you
are hereby notified that you have received this communication in error and
that any review, disclosure, dissemination, distribution or copying of it
or its contents is prohibited. If you have received this communication in
error, please notify me immediately by replying to this message and delete
this communication from your computer. Thank you.

Any opinions, expressed or implied, presented are solely those of the
author and do not necessarily represent the opinions of the agency or the
City.
=========



IDUG 2009 - Australasia * 18-20 March * Melbourne, Australia
IDUG.org was recently updated requiring members to use a new password. You
should have gotten an e-mail with the temporary password assigned to your
account. Please log in and update your member profile. If you are not
already an IDUG.org member, please register here.


**********

The information contained in this communication is confidential, private, proprietary, or otherwise privileged and is intended only for the use of the addressee. Unauthorized use, disclosure, distribution or copying is strictly prohibited and may be unlawful. If you have received this communication in error, please notify the sender immediately at (312)653-6000 in Illinois; (800)835-8699 in New Mexico; (918)560-3500 in Oklahoma; or (972)766-6900 in Texas.

**********


______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Phil Grainger

Re: [DB2v9 z/OS] Native SQL SP invocation
(in response to M. Khalid Khan)
DBM1 - this is one reason they are so much more efficient than
non-native ones



Much less cross-memory activity



Phil Grainger

CA

Senior Principal Product Manager

Phone: +44 (0)1753 577 733

Mobile: +44 (0)7970 125 752

eMail: [login to unmask email]



Ditton Park
Riding Court Road
Datchet
Slough
SL3 9LL



CA plc a company registered in England and Wales under company
registration number 1282495 with its registered office at the address
set out above. VAT number 697904179.



From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Sevetson, Phil
Sent: 12 January 2009 16:56
To: [login to unmask email]
Subject: [DB2-L] [DB2v9 z/OS] Native SQL SP invocation



Does anyone know off hand where native SQL Stored Procs run in DB2V9?
DBM1, or WLM?



--Phil Sevetson, NYCAPS DBA Support

Financial Information Services Agency of The City of New York

450 West 33rd Street, 4th Floor

New York, NY 10001

phone: (212) 857-1688

mailto: [login to unmask email] <mailto:[login to unmask email]>



________________________________

=========
Confidentiality Notice: This e-mail communication, and any attachments,
contains confidential and privileged information for the exclusive use
of the recipient(s) named above. If you are not an intended recipient,
or the employee or agent responsible to deliver it to an intended
recipient, you are hereby notified that you have received this
communication in error and that any review, disclosure, dissemination,
distribution or copying of it or its contents is prohibited. If you have
received this communication in error, please notify me immediately by
replying to this message and delete this communication from your
computer. Thank you.

Any opinions, expressed or implied, presented are solely those of the
author and do not necessarily represent the opinions of the agency or
the City.
=========



________________________________

IDUG 2009 - Australasia * 18-20 March * Melbourne, Australia
< http://idug.org/lsAU >

IDUG.org < http://www.idug.org > was recently updated requiring members
to use a new password. You should have gotten an e-mail with the
temporary password assigned to your account. Please log in and update
your member profile. If you are not already an IDUG.org member, please
register here. < http://www.idug.org/component/juser/register.html >



______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Peter Backlund

Re: [DB2v9 z/OS] Native SQL SP invocation
(in response to Phil Grainger)
DBM1

Sevetson, Phil wrote:

Does anyone know off hand where native SQL Stored Procs run in DB2V9?  DBM1, or WLM?

 

--Phil Sevetson, NYCAPS DBA Support

Financial Information Services Agency of The City of New York

450 West 33rd Street, 4th Floor

New York, NY 10001

phone: (212) 857-1688

mailto: [login to unmask email]ov

 


=========
Confidentiality Notice: This e-mail communication, and any attachments, contains confidential and privileged information for the exclusive use of the recipient(s) named above. If you are not an intended recipient, or the employee or agent responsible to deliver it to an intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify me immediately by replying to this message and delete this communication from your computer. Thank you.

Any opinions, expressed or implied, presented are solely those of the author and do not necessarily represent the opinions of the agency or the City.
=========



IDUG 2009 - Australasia * 18-20 March * Melbourne, Australia

IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register here.


No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.176 / Virus Database: 270.10.6/1888 - Release Date: 2009-01-12 07:04
-- Attend IDUG 2009, North America -- 11-15 May in Denver, Colorado Attend IDUG 2009, Europe -- 5- 9 October in Rome, Italy Learn more at http://www.idug.org +-------------------------------+---------------------------------+ | Peter G Backlund | Telephone: 08 - 38 69 08 | | Peter Backlund DB2-Konsult AB | Mobile: 070 - 764 7554 | | Rasundavagen 94 | Country Code (Sweden): 46 | | S-169 57 SOLNA | Skype: BacklundDB2 | | Sweden | E-mail: [login to unmask email] | +-------------------------------+---------------------------------+ | IBM Database GOLD Consultant | +-------------------------------+---------------------------------+ | Working with DB2 since 1981 ... and forever! | +-----------------------------------------------------------------+

IDUG 2009 - Australasia * 18-20 March * Melbourne, Australia

IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register here.

Ted MacNEIL

Re: [DB2v9 z/OS] Native SQL SP invocation
(in response to Peter Backlund)
>Does anyone know off hand where native SQL Stored Procs run in DB2V9?  DBM1, or WLM?

It definitely doesn't run in WLM!
There is no DB2, CICS, IMS, TSO, etc, code in the WLM.
It is an adjunct to the SRM, and as such makes decisions on priorities.
NOT understanding application code and DB schemas.

-
Too busy driving to stop for gas!


______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

William Favero

Re: [DB2v9 z/OS] Native SQL SP invocation
(in response to Ted MacNEIL)
DBM1

Willie

Ted MacNEIL wrote:
>> Does anyone know off hand where native SQL Stored Procs run in DB2V9? DBM1, or WLM?
>>
>
> It definitely doesn't run in WLM!
> There is no DB2, CICS, IMS, TSO, etc, code in the WLM.
> It is an adjunct to the SRM, and as such makes decisions on priorities.
> NOT understanding application code and DB schemas.
>
> -
> Too busy driving to stop for gas!
>
>
> ______________________________________________________________________
>
> * IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
> ______________________________________________________________________
>
>
>
> IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html
>
>
>

--
Willie
My DB2 blog --> http://blogs.ittoolbox.com/database/db2zos
Houston, TX, USA



______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

M. Khalid Khan

Re: [DB2v9 z/OS] Native SQL SP invocation
(in response to William Favero)
Ted
Don't get misled by DB2-land's colloquial speach. WLM here really meant
"stored procedure address space environment which is managed by WLM". But
they are all managed by WLM, you'd say. Right, but there used to be
another kind which was managed by DB2 (it still survives though
deprecated).
Hope it clears up some of the confusion.
Khalid

PS: It's not a good idea to answer emails while driving.


Ted MacNEIL wrote:
Does anyone know off hand where native SQL Stored Procs run in DB2V9?
DBM1, or WLM?


It definitely doesn't run in WLM!
There is no DB2, CICS, IMS, TSO, etc, code in the WLM.
It is an adjunct to the SRM, and as such makes decisions on priorities.
NOT understanding application code and DB schemas.

-
Too busy driving to stop for gas!

**********

The information contained in this communication is confidential, private, proprietary, or otherwise privileged and is intended only for the use of the addressee. Unauthorized use, disclosure, distribution or copying is strictly prohibited and may be unlawful. If you have received this communication in error, please notify the sender immediately at (312)653-6000 in Illinois; (800)835-8699 in New Mexico; (918)560-3500 in Oklahoma; or (972)766-6900 in Texas.

**********


______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Ted MacNEIL

Re: [DB2v9 z/OS] Native SQL SP invocation
(in response to M. Khalid Khan)
I don't understand your response.
What do you mean by managing?
All WLM does is determine dispatch priority, incluiding the 'old way'.
The 'management' is done by DBM!

And, the tag is a metaphore, not a way of life.
-
Too busy driving to stop for gas!

-----Original Message-----
From: "M. Khalid Khan" <[login to unmask email]>

Date: Mon, 12 Jan 2009 14:09:27
To: <[login to unmask email]>
Subject: Re: [DB2-L] [DB2v9 z/OS] Native SQL SP invocation


Ted
Don't get misled by DB2-land's colloquial speach. WLM here really meant
"stored procedure address space environment which is managed by WLM". But
they are all managed by WLM, you'd say. Right, but there used to be
another kind which was managed by DB2 (it still survives though
deprecated).
Hope it clears up some of the confusion.
Khalid

PS: It's not a good idea to answer emails while driving.


Ted MacNEIL wrote:
Does anyone know off hand where native SQL Stored Procs run in DB2V9?
DBM1, or WLM?


It definitely doesn't run in WLM!
There is no DB2, CICS, IMS, TSO, etc, code in the WLM.
It is an adjunct to the SRM, and as such makes decisions on priorities.
NOT understanding application code and DB schemas.

-
Too busy driving to stop for gas!

**********

The information contained in this communication is confidential, private, proprietary, or otherwise privileged and is intended only for the use of the addressee. Unauthorized use, disclosure, distribution or copying is strictly prohibited and may be unlawful. If you have received this communication in error, please notify the sender immediately at (312)653-6000 in Illinois; (800)835-8699 in New Mexico; (918)560-3500 in Oklahoma; or (972)766-6900 in Texas.

**********


______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Cathy Taddei

Re: [DB2v9 z/OS] Native SQL SP invocation
(in response to Ted MacNEIL)
The address spaces for WLM-managed stored procedures are started and stopped by WLM. WLM determines how many address spaces to start for each application environment, and stops them when they have been unused for a specified amount of time. Here is a direct quote from the DB2 V8 Installation Guide using this terminology:

DB2 stored procedures address space has been deprecated. Only stored procedures that were defined Version 7 can be run in the DB2-established stored address procedure space. All new stored procedures must be run in a WLM-managed stored procedure address space.
Hope this helps.

Cathy

________________________________
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Ted MacNEIL
Sent: Monday, January 12, 2009 12:31 PM
To: [login to unmask email]
Subject: Re: [DB2v9 z/OS] Native SQL SP invocation

I don't understand your response.
What do you mean by managing?
All WLM does is determine dispatch priority, incluiding the 'old way'.
The 'management' is done by DBM!

And, the tag is a metaphore, not a way of life.

-
Too busy driving to stop for gas!

________________________________
From: "M. Khalid Khan"
Date: Mon, 12 Jan 2009 14:09:27 -0600
To: <[login to unmask email]>
Subject: Re: [DB2-L] [DB2v9 z/OS] Native SQL SP invocation

Ted
Don't get misled by DB2-land's colloquial speach. WLM here really meant "stored procedure address space environment which is managed by WLM". But they are all managed by WLM, you'd say. Right, but there used to be another kind which was managed by DB2 (it still survives though deprecated).
Hope it clears up some of the confusion.
Khalid

PS: It's not a good idea to answer emails while driving.


Ted MacNEIL wrote:
Does anyone know off hand where native SQL Stored Procs run in DB2V9? DBM1, or WLM?


It definitely doesn't run in WLM!
There is no DB2, CICS, IMS, TSO, etc, code in the WLM.
It is an adjunct to the SRM, and as such makes decisions on priorities.
NOT understanding application code and DB schemas.

-
Too busy driving to stop for gas!

**********
The information contained in this communication is confidential, private, proprietary, or otherwise privileged and is intended only for the use of the addressee. Unauthorized use, disclosure, distribution or copying is strictly prohibited and may be unlawful. If you have received this communication in error, please notify the sender immediately at (312)653-6000 in Illinois; (800)835-8699 in New Mexico; (918)560-3500 in Oklahoma; or (972)766-6900 in Texas.
**********

------------------------------------------------------------------------------

This email is confidential and may be legally privileged.

It is intended solely for the addressee. Access to this email by anyone else, unless expressly approved by the sender or an authorized addressee, is unauthorized.

If you are not the intended recipient, any disclosure, copying, distribution or any action omitted or taken in reliance on it, is prohibited and may be unlawful. If you believe that you have received this email in error, please contact the sender, delete this e-mail and destroy all copies.

======


______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Wayne Driscoll

Re: [DB2v9 z/OS] Native SQL SP invocation
(in response to Cathy Taddei)
In this thread, WLM is short hand for WLM Application Environment Address
Space.

=======================
Wayne Driscoll
Omegamon DB2 L3 Support/Development
wdrisco(AT)us.ibm.com
=======================



Ted MacNEIL <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
01/12/2009 02:31 PM
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email]
cc

Subject
Re: [DB2-L] [DB2v9 z/OS] Native SQL SP invocation






I don't understand your response.What do you mean by managing?All WLM does
is determine dispatch priority, incluiding the 'old way'.The 'management'
is done by DBM!And, the tag is a metaphore, not a way of life.
-Too busy driving to stop for gas!
From: "M. Khalid Khan"
Date: Mon, 12 Jan 2009 14:09:27 -0600
To: <[login to unmask email]>
Subject: Re: [DB2-L] [DB2v9 z/OS] Native SQL SP invocation

Ted
Don't get misled by DB2-land's colloquial speach. WLM here really meant
"stored procedure address space environment which is managed by WLM". But
they are all managed by WLM, you'd say. Right, but there used to be
another kind which was managed by DB2 (it still survives though
deprecated).
Hope it clears up some of the confusion.
Khalid

PS: It's not a good idea to answer emails while driving.


Ted MacNEIL wrote:
Does anyone know off hand where native SQL Stored Procs run in DB2V9?
DBM1, or WLM?


It definitely doesn't run in WLM!
There is no DB2, CICS, IMS, TSO, etc, code in the WLM.
It is an adjunct to the SRM, and as such makes decisions on priorities.
NOT understanding application code and DB schemas.

-
Too busy driving to stop for gas!
**********
The information contained in this communication is confidential, private,
proprietary, or otherwise privileged and is intended only for the use of
the addressee. Unauthorized use, disclosure, distribution or copying is
strictly prohibited and may be unlawful. If you have received this
communication in error, please notify the sender immediately at
(312)653-6000 in Illinois; (800)835-8699 in New Mexico; (918)560-3500 in
Oklahoma; or (972)766-6900 in Texas.
**********


IDUG 2009 - Australasia * 18-20 March * Melbourne, Australia
IDUG.org was recently updated requiring members to use a new password. You
should have gotten an e-mail with the temporary password assigned to your
account. Please log in and update your member profile. If you are not
already an IDUG.org member, please register here.


______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Philip Sevetson

Re: [DB2v9 z/OS] Native SQL SP invocation
(in response to M. Khalid Khan)
Ted, I can't speak for Khalid but what _I_ meant by my original comment
was "Do Native SQL Procedures execute in a WLM-managed address space in
DB2 v9"? Sorry to have confused you.l



--Phil Sevetson



________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Ted MacNEIL
Sent: Monday, January 12, 2009 3:31 PM
To: [login to unmask email]
Subject: Re: [DB2-L] [DB2v9 z/OS] Native SQL SP invocation



I don't understand your response.
What do you mean by managing?
All WLM does is determine dispatch priority, incluiding the 'old way'.
The 'management' is done by DBM!

And, the tag is a metaphore, not a way of life.

-
Too busy driving to stop for gas!

________________________________

From: "M. Khalid Khan"
Date: Mon, 12 Jan 2009 14:09:27 -0600
To: <[login to unmask email]>
Subject: Re: [DB2-L] [DB2v9 z/OS] Native SQL SP invocation


Ted
Don't get misled by DB2-land's colloquial speach. WLM here really meant
"stored procedure address space environment which is managed by WLM".
But they are all managed by WLM, you'd say. Right, but there used to be
another kind which was managed by DB2 (it still survives though
deprecated).
Hope it clears up some of the confusion.
Khalid

PS: It's not a good idea to answer emails while driving.


Ted MacNEIL wrote:
Does anyone know off hand where native SQL Stored Procs run in DB2V9?
DBM1, or WLM?


It definitely doesn't run in WLM!
There is no DB2, CICS, IMS, TSO, etc, code in the WLM.
It is an adjunct to the SRM, and as such makes decisions on priorities.
NOT understanding application code and DB schemas.

-
Too busy driving to stop for gas!

**********
The information contained in this communication is confidential,
private, proprietary, or otherwise privileged and is intended only for
the use of the addressee. Unauthorized use, disclosure, distribution or
copying is strictly prohibited and may be unlawful. If you have received
this communication in error, please notify the sender immediately at
(312)653-6000 in Illinois; (800)835-8699 in New Mexico; (918)560-3500 in
Oklahoma; or (972)766-6900 in Texas.
**********



________________________________

IDUG 2009 - Australasia * 18-20 March * Melbourne, Australia
< http://idug.org/lsAU >

IDUG.org < http://www.idug.org > was recently updated requiring members
to use a new password. You should have gotten an e-mail with the
temporary password assigned to your account. Please log in and update
your member profile. If you are not already an IDUG.org member, please
register here. < http://www.idug.org/component/juser/register.html >



______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

M. Khalid Khan

Re: [DB2v9 z/OS] Native SQL SP invocation
(in response to Wayne Driscoll)
Ted
For some reason I didn't get your message but Cathy did an excellent job
explaining what I said.
Khalid






"Taddei, Cathy" <[login to unmask email]>
Sent by: "DB2 Data Base Discussion List" <[login to unmask email]>
01/12/2009 03:01 PM
Please respond to
"DB2 Database Discussion list at IDUG" <[login to unmask email]>


To
[login to unmask email]
cc

Subject
Re: [DB2-L] [DB2v9 z/OS] Native SQL SP invocation






The address spaces for WLM-managed stored procedures are started and
stopped by WLM. WLM determines how many address spaces to start for each
application environment, and stops them when they have been unused for a
specified amount of time. Here is a direct quote from the DB2 V8
Installation Guide using this terminology:

DB2 stored procedures address space has been deprecated. Only stored
procedures that were defined Version 7 can be run in the DB2-established
stored address procedure space. All new stored procedures must be run in a
WLM-managed stored procedure address space.
Hope this helps.

Cathy

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Ted MacNEIL
Sent: Monday, January 12, 2009 12:31 PM
To: [login to unmask email]
Subject: Re: [DB2v9 z/OS] Native SQL SP invocation

I don't understand your response.
What do you mean by managing?
All WLM does is determine dispatch priority, incluiding the 'old way'.
The 'management' is done by DBM!

And, the tag is a metaphore, not a way of life.
-
Too busy driving to stop for gas!


**********

The information contained in this communication is confidential, private, proprietary, or otherwise privileged and is intended only for the use of the addressee. Unauthorized use, disclosure, distribution or copying is strictly prohibited and may be unlawful. If you have received this communication in error, please notify the sender immediately at (312)653-6000 in Illinois; (800)835-8699 in New Mexico; (918)560-3500 in Oklahoma; or (972)766-6900 in Texas.

**********


______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Ted MacNEIL

Re: [DB2v9 z/OS] Native SQL SP invocation
(in response to Philip Sevetson)
>All new stored procedures must be run in a WLM-managed stored procedure address space.

I guess there's a terminology problem.
WLM determines the priority, and only starts more when DB2 requests them.
Yes, I can limit the number under WLM, but DB2 is the master.

-
Too busy driving to stop for gas!


______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Ted MacNEIL

Re: [DB2v9 z/OS] Native SQL SP invocation
(in response to Ted MacNEIL)
>In this thread, WLM is short hand for WLM Application Environment Address Space.

Yes, but WLM only does what DB2 asks for.
My question was:
"What do you mean by 'MANAGEMENT'".

Plus, I know.
I first set them up under OS/390 2.7, in 1999.
I think the issue is terminology.

DB2 manages the application.
WLM manages the priority, and the number, with some (minimal) input from the SYSPROG.

Where the SQL runs is not inside the WLM.

(This is getting bigger than the question)

-
Too busy driving to stop for gas!


______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Ted MacNEIL

Re: [DB2v9 z/OS] Native SQL SP invocation
(in response to Ted MacNEIL)
>Ted, I can’t speak for Khalid but what_I_ meant by my original comment was “Do Native SQL Procedures execute in a WLM-managed address space in DB2 v9”?  Sorry to have confused you.l

1. All address spaces are managed by WLM.
2. Technically, it's not an address space, its an enclave. WLM sets priority; DB2 does the work.

-
Too busy driving to stop for gas!


______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Ted MacNEIL

Re: [DB2v9 z/OS] Native SQL SP invocation
(in response to Ted MacNEIL)
Technically incorrect.
DB2 determines how many and manages the SQL.
WLM determines the priority, and you can control how many with WLM paramaters.
And, they are enclaves, not address spaces.
-
Too busy driving to stop for gas!

-----Original Message-----
From: "M. Khalid Khan" <[login to unmask email]>

Date: Mon, 12 Jan 2009 15:20:15
To: <[login to unmask email]>
Subject: Re: [DB2-L] [DB2v9 z/OS] Native SQL SP invocation


Ted
For some reason I didn't get your message but Cathy did an excellent job
explaining what I said.
Khalid






"Taddei, Cathy" <[login to unmask email]>
Sent by: "DB2 Data Base Discussion List" <[login to unmask email]>
01/12/2009 03:01 PM
Please respond to
"DB2 Database Discussion list at IDUG" <[login to unmask email]>


To
[login to unmask email]
cc

Subject
Re: [DB2-L] [DB2v9 z/OS] Native SQL SP invocation






The address spaces for WLM-managed stored procedures are started and
stopped by WLM. WLM determines how many address spaces to start for each
application environment, and stops them when they have been unused for a
specified amount of time. Here is a direct quote from the DB2 V8
Installation Guide using this terminology:

DB2 stored procedures address space has been deprecated. Only stored
procedures that were defined Version 7 can be run in the DB2-established
stored address procedure space. All new stored procedures must be run in a
WLM-managed stored procedure address space.
Hope this helps.

Cathy

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Ted MacNEIL
Sent: Monday, January 12, 2009 12:31 PM
To: [login to unmask email]
Subject: Re: [DB2v9 z/OS] Native SQL SP invocation

I don't understand your response.
What do you mean by managing?
All WLM does is determine dispatch priority, incluiding the 'old way'.
The 'management' is done by DBM!

And, the tag is a metaphore, not a way of life.
-
Too busy driving to stop for gas!


**********

The information contained in this communication is confidential, private, proprietary, or otherwise privileged and is intended only for the use of the addressee. Unauthorized use, disclosure, distribution or copying is strictly prohibited and may be unlawful. If you have received this communication in error, please notify the sender immediately at (312)653-6000 in Illinois; (800)835-8699 in New Mexico; (918)560-3500 in Oklahoma; or (972)766-6900 in Texas.

**********


______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Phil Grainger

Re: [DB2v9 z/OS] Native SQL SP invocation
(in response to Ted MacNEIL)
I think most of understood that the question originally asked was

"Do native SQL procedures get executed in the same place as WLM managed stored procedures, or somewhere else"

At least that's what the first 6 of us who said "No - in the DBM1 address space" thought

Phil G
CA

________________________________

From: DB2 Data Base Discussion List on behalf of Ted MacNEIL
Sent: Mon 12/01/2009 21:35
To: [login to unmask email]
Subject: Re: [DB2-L] [DB2v9 z/OS] Native SQL SP invocation



>In this thread, WLM is short hand for WLM Application Environment Address Space.

Yes, but WLM only does what DB2 asks for.
My question was:
"What do you mean by 'MANAGEMENT'".

Plus, I know.
I first set them up under OS/390 2.7, in 1999.
I think the issue is terminology.

DB2 manages the application.
WLM manages the priority, and the number, with some (minimal) input from the SYSPROG.

Where the SQL runs is not inside the WLM.

(This is getting bigger than the question)

-
Too busy driving to stop for gas!


______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html





______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Philip Sevetson

Re: [DB2v9 z/OS] Native SQL SP invocation
(in response to Phil Grainger)
Look... take it up with IBM, okay? It's their terminology, used in their manuals, when stored procedures were changed in DB2V7.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Ted MacNEIL
Sent: Monday, January 12, 2009 4:38 PM
To: [login to unmask email]
Subject: Re: [DB2-L] [DB2v9 z/OS] Native SQL SP invocation

>Ted, I can't speak for Khalid but what_I_ meant by my original comment was "Do Native SQL Procedures execute in a WLM-managed address space in DB2 v9"?  Sorry to have confused you.l

1. All address spaces are managed by WLM.
2. Technically, it's not an address space, its an enclave. WLM sets priority; DB2 does the work.

-
Too busy driving to stop for gas!


______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html


______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Cathy Taddei

Re: [DB2v9 z/OS] Native SQL SP invocation
(in response to Philip Sevetson)
Ted, sorry to disagree, but you're wrong -- they are address spaces. I wasn't doing DB2 in 1999, so I can't speak to your early experiences, but today they run as separate started tasks, not enclaves. Maybe you're thinking of enclaves for DDF threads?

WLM, not DB2, determines how many address spaces to start. Compare with WLM-managed initiators -- WLM determines whether to raise the multiprogramming level of the system, not JES2.

Regards,
Cathy

________________________________
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Ted MacNEIL
Sent: Monday, January 12, 2009 1:40 PM
To: [login to unmask email]
Subject: Re: [DB2v9 z/OS] Native SQL SP invocation

Technically incorrect.
DB2 determines how many and manages the SQL.
WLM determines the priority, and you can control how many with WLM paramaters.
And, they are enclaves, not address spaces.

-
Too busy driving to stop for gas!

________________________________
From: "M. Khalid Khan"
Date: Mon, 12 Jan 2009 15:20:15 -0600
To: <[login to unmask email]>
Subject: Re: [DB2-L] [DB2v9 z/OS] Native SQL SP invocation

Ted
For some reason I didn't get your message but Cathy did an excellent job explaining what I said.
Khalid





"Taddei, Cathy" <[login to unmask email]>
Sent by: "DB2 Data Base Discussion List" <[login to unmask email]>

01/12/2009 03:01 PM
Please respond to
"DB2 Database Discussion list at IDUG" <[login to unmask email]>


To
[login to unmask email]
cc
Subject
Re: [DB2-L] [DB2v9 z/OS] Native SQL SP invocation





The address spaces for WLM-managed stored procedures are started and stopped by WLM. WLM determines how many address spaces to start for each application environment, and stops them when they have been unused for a specified amount of time. Here is a direct quote from the DB2 V8 Installation Guide using this terminology:

DB2 stored procedures address space has been deprecated. Only stored procedures that were defined Version 7 can be run in the DB2-established stored address procedure space. All new stored procedures must be run in a WLM-managed stored procedure address space.
Hope this helps.

Cathy

________________________________
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Ted MacNEIL
Sent: Monday, January 12, 2009 12:31 PM
To: [login to unmask email]
Subject: Re: [DB2v9 z/OS] Native SQL SP invocation

I don't understand your response.
What do you mean by managing?
All WLM does is determine dispatch priority, incluiding the 'old way'.
The 'management' is done by DBM!

And, the tag is a metaphore, not a way of life.

-
Too busy driving to stop for gas!

**********
The information contained in this communication is confidential, private, proprietary, or otherwise privileged and is intended only for the use of the addressee. Unauthorized use, disclosure, distribution or copying is strictly prohibited and may be unlawful. If you have received this communication in error, please notify the sender immediately at (312)653-6000 in Illinois; (800)835-8699 in New Mexico; (918)560-3500 in Oklahoma; or (972)766-6900 in Texas.
**********

------------------------------------------------------------------------------

This email is confidential and may be legally privileged.

It is intended solely for the addressee. Access to this email by anyone else, unless expressly approved by the sender or an authorized addressee, is unauthorized.

If you are not the intended recipient, any disclosure, copying, distribution or any action omitted or taken in reliance on it, is prohibited and may be unlawful. If you believe that you have received this email in error, please contact the sender, delete this e-mail and destroy all copies.

======


______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Myron Miller

Re: [DB2v9 z/OS] Native SQL SP invocation
(in response to Cathy Taddei)
Actually it runs with an Enclave but runs in a specified address space that has to be started and managed by DBM1 as an enclave under the control of that address space. Enclaves do not have JCL. Address spaces do. An address space can have 1 or more enclaves tunning under it's control, ie CICS.

Myron



________________________________
From: Ted MacNEIL <[login to unmask email]>
To: [login to unmask email]
Sent: Monday, January 12, 2009 4:40:06 PM
Subject: Re: [DB2-L] [DB2v9 z/OS] Native SQL SP invocation

Technically incorrect.
DB2 determines how many and manages the SQL.
WLM determines the priority, and you can control how many with WLM paramaters.
And, they are enclaves, not address spaces.
-
Too busy driving to stop for gas!
________________________________
From: "M. Khalid Khan"
Date: Mon, 12 Jan 2009 15:20:15 -0600
To: <[login to unmask email]>
Subject: Re: [DB2-L] [DB2v9 z/OS] Native SQL SP invocation

Ted
For some reason I didn't get your message but Cathy did an excellent job explaining what I said.
Khalid






"Taddei, Cathy" <[login to unmask email]>
Sent by: "DB2 Data Base Discussion List" <[login to unmask email]>
01/12/2009 03:01 PM
Please respond to
"DB2 Database Discussion list at IDUG" <[login to unmask email]>
To [login to unmask email]
cc
Subject Re: [DB2-L] [DB2v9 z/OS] Native SQL SP invocation




The address spaces for WLM-managed stored procedures are started and stopped by WLM. WLM determines how many address spaces to start for each application environment, and stops them when they have been unused for a specified amount of time. Here is a direct quote from the DB2 V8 Installation Guide using this terminology:

DB2 stored procedures address space has been deprecated. Only stored procedures that were defined Version 7 can be run in the DB2-established stored address procedure space. All new stored procedures must be run in a WLM-managed stored procedure address space.
Hope this helps.

Cathy

________________________________
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Ted MacNEIL
Sent: Monday, January 12, 2009 12:31 PM
To: [login to unmask email]
Subject: Re: [DB2v9 z/OS] Native SQL SP invocation

I don't understand your response.
What do you mean by managing?
All WLM does is determine dispatch priority, incluiding the 'old way'.
The 'management' is done by DBM!

And, the tag is a metaphore, not a way of life.
-
Too busy driving to stop for gas!
**********
The information contained in this communication is confidential, private, proprietary, or otherwise privileged and is intended only for the use of the addressee. Unauthorized use, disclosure, distribution or copying is strictly prohibited and may be unlawful. If you have received this communication in error, please notify the sender immediately at (312)653-6000 in Illinois; (800)835-8699 in New Mexico; (918)560-3500 in Oklahoma; or (972)766-6900 in Texas.
**********
________________________________

IDUG 2009 - Australasia * 18-20 March * Melbourne, AustraliaIDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register here.


______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Edward Long

Re: [DB2v9 z/OS] Native SQL SP invocation
(in response to Myron Miller)
DB2 WLM managed Stored Procedure address spaces are both address spaces and enclaves.

Kind of like light being a particle and a wave.

Edward Long


--- On Mon, 1/12/09, Ted MacNEIL <[login to unmask email]> wrote:

> From: Ted MacNEIL <[login to unmask email]>
> Subject: Re: [DB2-L] [DB2v9 z/OS] Native SQL SP invocation
> To: [login to unmask email]
> Date: Monday, January 12, 2009, 4:40 PM
> Technically incorrect.
> DB2 determines how many and manages the SQL.
> WLM determines the priority, and you can control how many
> with WLM paramaters.
> And, they are enclaves, not address spaces.
> -
> Too busy driving to stop for gas!
>
> -----Original Message-----
> From: "M. Khalid Khan"
> <[login to unmask email]>
>
> Date: Mon, 12 Jan 2009 15:20:15
> To: <[login to unmask email]>
> Subject: Re: [DB2-L] [DB2v9 z/OS] Native SQL SP invocation
>
>
> Ted
> For some reason I didn't get your message but Cathy did
> an excellent job
> explaining what I said.
> Khalid
>
>
>
>
>
>
> "Taddei, Cathy"
> <[login to unmask email]>
> Sent by: "DB2 Data Base Discussion List"
> <[login to unmask email]>
> 01/12/2009 03:01 PM
> Please respond to
> "DB2 Database Discussion list at IDUG"
> <[login to unmask email]>
>
>
> To
> [login to unmask email]
> cc
>
> Subject
> Re: [DB2-L] [DB2v9 z/OS] Native SQL SP invocation
>
>
>
>
>
>
> The address spaces for WLM-managed stored procedures are
> started and
> stopped by WLM. WLM determines how many address spaces to
> start for each
> application environment, and stops them when they have been
> unused for a
> specified amount of time. Here is a direct quote from the
> DB2 V8
> Installation Guide using this terminology:
>
> DB2 stored procedures address space has been deprecated.
> Only stored
> procedures that were defined Version 7 can be run in the
> DB2-established
> stored address procedure space. All new stored procedures
> must be run in a
> WLM-managed stored procedure address space.
> Hope this helps.
>
> Cathy
>
> From: DB2 Data Base Discussion List
> [mailto:[login to unmask email] On Behalf
> Of Ted MacNEIL
> Sent: Monday, January 12, 2009 12:31 PM
> To: [login to unmask email]
> Subject: Re: [DB2v9 z/OS] Native SQL SP invocation
>
> I don't understand your response.
> What do you mean by managing?
> All WLM does is determine dispatch priority, incluiding the
> 'old way'.
> The 'management' is done by DBM!
>
> And, the tag is a metaphore, not a way of life.
> -
> Too busy driving to stop for gas!
>
>
> **********
>
> The information contained in this communication is
> confidential, private, proprietary, or otherwise privileged
> and is intended only for the use of the addressee.
> Unauthorized use, disclosure, distribution or copying is
> strictly prohibited and may be unlawful. If you have
> received this communication in error, please notify the
> sender immediately at (312)653-6000 in Illinois;
> (800)835-8699 in New Mexico; (918)560-3500 in Oklahoma; or
> (972)766-6900 in Texas.
>
> **********
>
>
> ______________________________________________________________________
>
> * IDUG 2009 Rome, Italy * 5-9 October *
> http://IDUG.ORG/Events *
> ______________________________________________________________________
>
>
>
> IDUG.org was recently updated requiring members to use a
> new password. You should have gotten an e-mail with the
> temporary password assigned to your account. Please log in
> and update your member profile. If you are not already an
> IDUG.org member, please register at
> http://www.idug.org/component/juser/register.html


______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

David Seibert

Re: [DB2v9 z/OS] Native SQL SP invocation
(in response to Edward Long)
I agree that terminology is the problem here.

Maybe real examples will clarify.
Here are tasks from our output queue for a DB2 subsystem.
The last 4 in the list are for the address spaces everyone recognizes.
The first 6 are from address spaces for DB2 stored procedure address
spaces for WLM-managed DB2 SPs.

DB2 native SQL stored procedures run in the D909DBM1 address space.
Other DB2 stored procedures run in the D909WLM address spaces and others
like them.

D909WLM S0660863 01/08/2009
D909WLM S0660884 01/08/2009
D909WLM S0660859 01/08/2009
D909WLM S0663236 01/08/2009
D909WLM S0668489 01/09/2009
D909WLM S0668489 01/09/2009
D909DIST S0658760 01/10/2009
D909DBM1 S0658758 01/10/2009
D909IRLM S0658757 01/10/2009
D009MSTR S0658756 01/10/2009


Dave


The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it.

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Grainger, Phil
Sent: Monday, January 12, 2009 4:55 PM
To: [login to unmask email]
Subject: Re: [DB2-L] [DB2v9 z/OS] Native SQL SP invocation

I think most of understood that the question originally asked was

"Do native SQL procedures get executed in the same place as WLM managed
stored procedures, or somewhere else"

At least that's what the first 6 of us who said "No - in the DBM1
address space" thought

Phil G
CA

________________________________

From: DB2 Data Base Discussion List on behalf of Ted MacNEIL
Sent: Mon 12/01/2009 21:35
To: [login to unmask email]
Subject: Re: [DB2-L] [DB2v9 z/OS] Native SQL SP invocation

>In this thread, WLM is short hand for WLM Application Environment
Address Space.

Yes, but WLM only does what DB2 asks for.
My question was:
"What do you mean by 'MANAGEMENT'".

Plus, I know.
I first set them up under OS/390 2.7, in 1999.
I think the issue is terminology.

DB2 manages the application.
WLM manages the priority, and the number, with some (minimal) input from
the SYSPROG.

Where the SQL runs is not inside the WLM.

(This is getting bigger than the question)
Too busy driving to stop for gas!

______________________________________________________________________

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




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Ted MacNEIL

Re: [DB2v9 z/OS] Native SQL SP invocation
(in response to David Seibert)
>Look... take it up with IBM, okay? It's their terminology, used in their manuals, when stored procedures were changed in DB2V7.

IBM wasn't the one discussing/questioning the issue.
-
Too busy driving to stop for gas!

______________________________________________________________________

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




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Wayne Driscoll

Re: [DB2v9 z/OS] Native SQL SP invocation
(in response to Ted MacNEIL)
But the post here was using the terminology as it is used in the DB2
manuals, you were questioning it. At least 6 or 7 posters understood the
question correctly and gave the right answer.

=======================
Wayne Driscoll
Omegamon DB2 L3 Support/Development
wdrisco(AT)us.ibm.com
=======================



Ted MacNEIL <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
01/13/2009 12:44 AM
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email]
cc

Subject
Re: [DB2-L] [DB2v9 z/OS] Native SQL SP invocation






>Look... take it up with IBM, okay? It's their terminology, used in their
manuals, when stored procedures were changed in DB2V7.

IBM wasn't the one discussing/questioning the issue.
-
Too busy driving to stop for gas!



IDUG.org was recently updated requiring members to use a new password. You
should have gotten an e-mail with the temporary password assigned to your
account. Please log in and update your member profile. If you are not
already an IDUG.org member, please register at
http://www.idug.org/component/juser/register.html


______________________________________________________________________

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




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html