RCT Plan Used? - DB2 V8 for z/OS

Jay Reavill

RCT Plan Used? - DB2 V8 for z/OS
Hello everyone,



Got a question that I can't seem to find the answer to...



If a transaction entry is defined in the RCT with a different plan than
the pool and the transaction overflows to the pool which plan is used -
the entry or the pool?



As always... Thanks!

Jay



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

Jay Reavill

DBA

Fidelity National Information Services, Inc.

11601 Roosevelt Blvd., St. Petersburg, FL. 33716

Office: 727-227-2144 | Cell: 727-215-5794

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

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



_____________

The information contained in this message is proprietary and/or confidential. If you are not the intended recipient, please: (i) delete the message and all copies; (ii) do not disclose, distribute or use the message in any manner; and (iii) notify the sender immediately. In addition, please be aware that any message addressed to our domain is subject to archiving and review by persons other than the intended recipient. Thank you.
_____________

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Carol Anne Sutfin

Re: RCT Plan Used? - DB2 V8 for z/OS
(in response to Jay Reavill)
Jay,

It takes the Plan from the POOL definition along with the Authorization and
the DPMODE.

Carol Sutfin
Corporate DBA
Regions Financial Corp.
(205)261-5214
[login to unmask email]



From: "Reavill, Jay" <[login to unmask email]>
To: [login to unmask email]
Date: 09/17/2010 04:48 PM
Subject: [DB2-L] RCT Plan Used? - DB2 V8 for z/OS
Sent by: IDUG DB2-L <[login to unmask email]>



Hello everyone,

Got a question that I can’t seem to find the answer to…

If a transaction entry is defined in the RCT with a different plan than the
pool and the transaction overflows to the pool which plan is used – the
entry or the pool?

As always… Thanks!
Jay

------------------------------------------------------------------------
Jay Reavill
DBA
Fidelity National Information Services, Inc.
11601 Roosevelt Blvd., St. Petersburg, FL. 33716
Office: 727-227-2144 | Cell: 727-215-5794
[login to unmask email]
------------------------------------------------------------------------



_____________

The information contained in this message is proprietary and/or
confidential. If you are not the intended recipient, please: (i) delete the
message and all copies; (ii) do not disclose, distribute or use the message
in any manner; and (iii) notify the sender immediately. In addition, please
be aware that any message addressed to our domain is subject to archiving
and review by persons other than the intended recipient. Thank you.
_____________







The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are
not already an IDUG member, please register here.


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Jay Reavill

Re: RCT Plan Used? - DB2 V8 for z/OS
(in response to Carol Anne Sutfin)
Thanks Carol. It makes sense that it would. That was our belief, but
just needed some confirmation. We have a debate going on with a
developer and now we have the ammo to shut'm down.

------------------------------------------------------------------------
Jay Reavill
DBA
Fidelity National Information Services, Inc.
11601 Roosevelt Blvd., St. Petersburg, FL. 33716
Office: 727-227-2144 | Cell: 727-215-5794
[login to unmask email]
------------------------------------------------------------------------

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of
[login to unmask email]
Sent: Friday, September 17, 2010 6:11 PM
To: [login to unmask email]
Subject: Re: [DB2-L] RCT Plan Used? - DB2 V8 for z/OS

Jay,

It takes the Plan from the POOL definition along with the Authorization
and
the DPMODE.

Carol Sutfin
Corporate DBA
Regions Financial Corp.
(205)261-5214
[login to unmask email]



From: "Reavill, Jay" <[login to unmask email]>
To: [login to unmask email]
Date: 09/17/2010 04:48 PM
Subject: [DB2-L] RCT Plan Used? - DB2 V8 for z/OS
Sent by: IDUG DB2-L <[login to unmask email]>



Hello everyone,

Got a question that I can't seem to find the answer to...

If a transaction entry is defined in the RCT with a different plan than
the
pool and the transaction overflows to the pool which plan is used - the
entry or the pool?

As always... Thanks!
Jay

------------------------------------------------------------------------
Jay Reavill
DBA
Fidelity National Information Services, Inc.
11601 Roosevelt Blvd., St. Petersburg, FL. 33716
Office: 727-227-2144 | Cell: 727-215-5794
[login to unmask email]
------------------------------------------------------------------------



_____________

The information contained in this message is proprietary and/or
confidential. If you are not the intended recipient, please: (i) delete
the
message and all copies; (ii) do not disclose, distribute or use the
message
in any manner; and (iii) notify the sender immediately. In addition,
please
be aware that any message addressed to our domain is subject to
archiving
and review by persons other than the intended recipient. Thank you.
_____________







The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are
not already an IDUG member, please register here.


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is
it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is the home of IDUG's Listserv

_____________

The information contained in this message is proprietary and/or confidential. If you are not the intended recipient, please: (i) delete the message and all copies; (ii) do not disclose, distribute or use the message in any manner; and (iii) notify the sender immediately. In addition, please be aware that any message addressed to our domain is subject to archiving and review by persons other than the intended recipient. Thank you.
_____________

_____________________________________________________________________
* IDUG EMEA * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EMEA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Robert Catterall

Re: RCT Plan Used? - DB2 V8 for z/OS
(in response to Jay Reavill)
At two months, this may be a record for late contributions to a thread
(shows how behind I've gotten with respect to DB2-L entries).

The CICS DB2 Guide (I'm looking at the one for CICS V4R1 -- the document ID
is SC34-7011) makes it clear that when a transaction with a DB2ENTRY
resource overflows to the pool, it WILL NOT use the plan specified for the
pool -- it will still use the plan specified for the transaction in the
DB2ENTRY resource. I quote (from page 24 in the above-referenced manual --
emphasis added by me):

"If THREADWAIT=POOL is specified, requests for threads are transferred to
the pool when the value of THREADLIMIT is exceeded. When a transaction
overflows to the pool, the transaction is now controlled by the PRIORITY,
THREADLIMIT, and THREADWAIT attributes that are specified for pool threads
in the DB2CONN definition, and those attributes in the DB2ENTRY definition
are ignored. *The remaining attributes that are specified in the DB2ENTRY
definition for the entry thread still apply to the transaction, that is,
ACCOUNTREC, AUTHID or AUTHTYPE, DROLLBACK, and PLAN* or PLANEXITNAME."

This is the way I've always known pool-overflow to work. The plan specified
for the pool should only be used if the transaction's DB2ENTRY is disabled
and the DISABLEDACT keyword is set to POOL.

Robert


On Sat, Sep 18, 2010 at 5:34 AM, Reavill, Jay
<[login to unmask email]>wrote:

> Thanks Carol. It makes sense that it would. That was our belief, but
> just needed some confirmation. We have a debate going on with a
> developer and now we have the ammo to shut'm down.
>
> ------------------------------------------------------------------------
> Jay Reavill
> DBA
> Fidelity National Information Services, Inc.
> 11601 Roosevelt Blvd., St. Petersburg, FL. 33716
> Office: 727-227-2144 | Cell: 727-215-5794
> [login to unmask email]
> ------------------------------------------------------------------------
>
> -----Original Message-----
> From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of
> [login to unmask email]
> Sent: Friday, September 17, 2010 6:11 PM
> To: [login to unmask email]
> Subject: Re: [DB2-L] RCT Plan Used? - DB2 V8 for z/OS
>
> Jay,
>
> It takes the Plan from the POOL definition along with the Authorization
> and
> the DPMODE.
>
> Carol Sutfin
> Corporate DBA
> Regions Financial Corp.
> (205)261-5214
> [login to unmask email]
>
>
>
> From: "Reavill, Jay" <[login to unmask email]>
> To: [login to unmask email]
> Date: 09/17/2010 04:48 PM
> Subject: [DB2-L] RCT Plan Used? - DB2 V8 for z/OS
> Sent by: IDUG DB2-L <[login to unmask email]>
>
>
>
> Hello everyone,
>
> Got a question that I can't seem to find the answer to...
>
> If a transaction entry is defined in the RCT with a different plan than
> the
> pool and the transaction overflows to the pool which plan is used - the
> entry or the pool?
>
> As always... Thanks!
> Jay
>
> ------------------------------------------------------------------------
> Jay Reavill
> DBA
> Fidelity National Information Services, Inc.
> 11601 Roosevelt Blvd., St. Petersburg, FL. 33716
> Office: 727-227-2144 | Cell: 727-215-5794
> [login to unmask email]
> ------------------------------------------------------------------------
>
>
>
> _____________
>
> The information contained in this message is proprietary and/or
> confidential. If you are not the intended recipient, please: (i) delete
> the
> message and all copies; (ii) do not disclose, distribute or use the
> message
> in any manner; and (iii) notify the sender immediately. In addition,
> please
> be aware that any message addressed to our domain is subject to
> archiving
> and review by persons other than the intended recipient. Thank you.
> _____________
>
>
>
>
>
>
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
> are
> not already an IDUG member, please register here.
>
>
> _____________________________________________________________________
> * IDUG North America * Anaheim, California * May 2-6 2011 *
> http://IDUG.ORG/NA *
> * If you are going to attend only one conference this year, this is
> it! *
> _____________________________________________________________________
> http://www.IDUG.org/mentor
> Mentoring should be a rewarding experience for everyone...
> IDUG is offering up to 80% off when you both come to the conference!
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
> is the home of IDUG's Listserv
>
> _____________
>
> The information contained in this message is proprietary and/or
> confidential. If you are not the intended recipient, please: (i) delete the
> message and all copies; (ii) do not disclose, distribute or use the message
> in any manner; and (iii) notify the sender immediately. In addition, please
> be aware that any message addressed to our domain is subject to archiving
> and review by persons other than the intended recipient. Thank you.
> _____________
>
> _____________________________________________________________________
> * IDUG EMEA * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EMEA*
> * Your only source for independent, unbiased, and trusted DB2
> information. *
> ** The most DB2 technical sessions of any conference
> ** Access IBM experts and developers
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
> the home of IDUG's Listserv
>



--
Robert Catterall
DB2 Specialist
IBM US - East
[login to unmask email]

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv