SV: [DB2-L] Is DB2 recycle required when applying PTFs?

Olle Brostrom

SV: [DB2-L] Is DB2 recycle required when applying PTFs?

Hi Donna,
Like others say, DB2 need to be bounced when applying maintenance which is to be executed by DB2 itself.
In addition to that we quite often use to copy the new modules (SDSNLOAD) when DB2 is still active and then several hours later in the night activate them by doing a restart of the DB2 system, until now we have not went into any trouble with this action.

Olle Broström
Databasteknik, DB2 för z/OS
IT Service

Swedbank AB (publ)
www.swedbank.se


-----Ursprungligt meddelande-----
Från: DB2 Data Base Discussion List [mailto:[login to unmask email] För Donna Domovic
Skickat: den 9 januari 2009 15:24
Till: [login to unmask email]
Ämne: [DB2-L] Is DB2 recycle required when applying PTFs?

Hello,

When applying a DB2 PTF to resolve an issue, we've always applied the fix to the production DB2 loadlib then stopped and restarted DB2. The question I have is, with the newer versions of DB2 (ie v7, v8, v9, etc.) is the DB2 stop and start always necessary to pick up the fix? If not, is there any way to tell when a stop and start is required?

Thanks,
Donna Domovic


______________________________________________________________________

* 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

Max Scarpa

Re: Is DB2 recycle required when applying PTFs?
(in response to Olle Brostrom)
Hi Phil

Sorry but I don't agree. I saw and tested on my skin many PTFs without a
++HOLD requirinq a bouncing of DB2 but not working when applied without a
DB2 stop/start. ANd this causes some troubles sometimes.

Max Scarpa




"Grainger, Phil" <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
09/01/09 15.56
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email]
cc

Subject
Re: [DB2-L] Is DB2 recycle required when applying PTFs?






Sorry, I can't resist but "It Depends" :)

I think, in general, the answer is NO - if a recycle of DB2 was required,
the ++HOLD data would say so

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.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Donna Domovic
Sent: 09 January 2009 14:24
To: [login to unmask email]
Subject: [DB2-L] Is DB2 recycle required when applying PTFs?

Hello,

When applying a DB2 PTF to resolve an issue, we've always applied the fix
to
the production DB2 loadlib then stopped and restarted DB2. The question I

have is, with the newer versions of DB2 (ie v7, v8, v9, etc.) is the DB2
stop
and start always necessary to pick up the fix? If not, is there any way
to tell
when a stop and start is required?

Thanks,
Donna Domovic


______________________________________________________________________

* 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



______________________________________________________________________

* 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

Jim Tonchick

Re: Is DB2 recycle required when applying PTFs?
(in response to Max Scarpa)
I have seen HOLD ACTION instructions that say after application of a PTF, a utility (batch job) may react differently until the DBM1 address space "refreshes" the changed module.? Unless the module is fetched & loaded each time it is executed (very unlikely) it will take a recycle of DB2 to get the DBM1 to load the new version of the module into memory like Ed said below.? While the text of the ++HOLD doesn't explicitly say "a recycle of DB2 is required", the description implies that one is.

So, yes, "It depends".

Jim Tonchick

-----Original Message-----
From: Ed Long <[login to unmask email]>
To: [login to unmask email]
Sent: Fri, 9 Jan 2009 11:50 am
Subject: Re: [DB2-L] Is DB2 recycle required when applying PTFs?



My view slightly differs from Phil's on this. The Hold data for DB2 will tell
you if an IPL, REBIND, or other action is required.

I don't recall ever seeing a DB2 recycle listed.

Virtually all DB2 maintenance actions, including the one I did on Tuesday night,
only 'activate' when DB2 is bounced. After all, some amount of SDSNLOAD is
loaded into memory; the changed modules only run when loaded into memory.

The one exception I can think of might be maintenance applied to a standalone
module like DSN1COPY.

Its usually considered bad karma to apply maintenance to a running system.

Drop DB2 before you apply the maintenance.
Edward Long


--- On Fri, 1/9/09, Grainger, Phil <[login to unmask email]> wrote:

> From: Grainger, Phil <[login to unmask email]>
> Subject: Re: [DB2-L] Is DB2 recycle required when applying PTFs?
> To: [login to unmask email]
> Date: Friday, January 9, 2009, 9:56 AM
> Sorry, I can't resist but "It Depends" :)
>
> I think, in general, the answer is NO - if a recycle of DB2
> was required, the ++HOLD data would say so
>
> 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.
>
> -----Original Message-----
> From: DB2 Data Base Discussion List
> [mailto:[login to unmask email] On Behalf Of Donna Domovic
> Sent: 09 January 2009 14:24
> To: [login to unmask email]
> Subject: [DB2-L] Is DB2 recycle required when applying
> PTFs?
>
> Hello,
>
> When applying a DB2 PTF to resolve an issue, we've
> always applied the fix to
> the production DB2 loadlib then stopped and restarted DB2.
> The question I
> have is, with the newer versions of DB2 (ie v7, v8, v9,
> etc.) is the DB2 stop
> and start always necessary to pick up the fix? If not, is
> there any way to tell

> when a stop and start is required?
>
> Thanks,
> Donna Domovic
>
>
> ______________________________________________________________________
>
> * 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


______________________________________________________________________

* 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 Melbourne, Australia * 18-20 March * 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

Jim Tonchick

Re: Is DB2 recycle required when applying PTFs?
(in response to Jim Tonchick)
As I've been reading this thread, I noticed that no one has mentioned the topic of change management.?

First, what software vendor suggests that you execute directly out of your SMP/E target zone libraries?? I sure don't want my payroll checks coming out of a database system while an APPLY or RESTORE is being run by a sysprog.

Second, what company doesn't have procedures in place to restrict when changes can be applied to major enterprise environments?? As a result, changes are usually made in "off hours" using methods that reduce down time.? These are usually when an individual subsystem is down to run the change job (rename of the base dataset or change of an alias to the "new" copy).? Exceptions to these are changes designed to be performed "on the fly" like SDSNEXIT zparm modules via the SET SYSPARM command.

So for the majority of situations, the target DB2 subsystem us usually "down" at the moment the SDSNLOAD is updated.

Jim Tonchick

-----Original Message-----
From: Max Scarpa <[login to unmask email]>
To: [login to unmask email]
Sent: Mon, 12 Jan 2009 2:19 am
Subject: Re: [DB2-L] Is DB2 recycle required when applying PTFs?



Hi Phil

Sorry but I don't agree. I saw and tested on my skin many PTFs without a ++HOLD requirinq a bouncing of DB2 but not working when applied without a ?DB2 stop/start. ? ANd this causes some troubles sometimes.

Max Scarpa







"Grainger, Phil" <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
09/01/09 15.56




Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>













To


[login to unmask email]




cc







Subject


Re: [DB2-L] Is DB2 recycle required when applying PTFs?






















Sorry, I can't resist but "It Depends" :)

I think, in general, the answer is NO - if a recycle of DB2 was required, the ++HOLD data would say so

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.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Donna Domovic
Sent: 09 January 2009 14:24
To: [login to unmask email]
Subject: [DB2-L] Is DB2 recycle required when applying PTFs?

Hello,

When applying a DB2 PTF to resolve an issue, we've always applied the fix to
the production DB2 loadlib then stopped and restarted DB2. ?The question I
have is, with the newer versions of DB2 (ie v7, v8, v9, etc.) is the DB2 stop
and start always necessary to pick up the fix? ?If not, is there any way to tell
when a stop and start is required?

Thanks,
Donna Domovic


______________________________________________________________________

* 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



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.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 Melbourne, Australia * 18-20 March * 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

Max Scarpa

Re: Is DB2 recycle required when applying PTFs?
(in response to Jim Tonchick)
I saw it many times as well. The modified module was operative after PTF
application when a new batch was started OR a bouncing of DB2 was
performed.

But in many other situation (I remember one for LOBs, but there were many)
there was *no* ++HOLD nor any indication about DB2 bouncing so I wondered
if there was a change in IBM's policy or DB2 became so smart as MQ did (MQ
is half DB2....). In these particular cases it was not.

I saw it even for some z/OS PTFs.

Just my personal experience and nothing else.

Max Scarpa






[login to unmask email]
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
14/01/09 07.27
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email]
cc

Subject
Re: [DB2-L] Is DB2 recycle required when applying PTFs?






I have seen HOLD ACTION instructions that say after application of a PTF,
a utility (batch job) may react differently until the DBM1 address space
"refreshes" the changed module. Unless the module is fetched & loaded
each time it is executed (very unlikely) it will take a recycle of DB2 to
get the DBM1 to load the new version of the module into memory like Ed
said below. While the text of the ++HOLD doesn't explicitly say "a
recycle of DB2 is required", the description implies that one is.

So, yes, "It depends".

Jim Tonchick

-----Original Message-----
From: Ed Long <[login to unmask email]>
To: [login to unmask email]
Sent: Fri, 9 Jan 2009 11:50 am
Subject: Re: [DB2-L] Is DB2 recycle required when applying PTFs?

My view slightly differs from Phil's on this. The Hold data for DB2 will
tell
you if an IPL, REBIND, or other action is required.

I don't recall ever seeing a DB2 recycle listed.

Virtually all DB2 maintenance actions, including the one I did on Tuesday
night,
only 'activate' when DB2 is bounced. After all, some amount of SDSNLOAD is

loaded into memory; the changed modules only run when loaded into memory.

The one exception I can think of might be maintenance applied to a
standalone
module like DSN1COPY.

Its usually considered bad karma to apply maintenance to a running system.

Drop DB2 before you apply the maintenance.
Edward Long


--- On Fri, 1/9/09, Grainger, Phil <[login to unmask email]> wrote:

> From: Grainger, Phil <[login to unmask email]>
> Subject: Re: [DB2-L] Is DB2 recycle required when applying PTFs?
> To: [login to unmask email]
> Date: Friday, January 9, 2009, 9:56 AM
> Sorry, I can't resist but "It Depends" :)
>
> I think, in general, the answer is NO - if a recycle of DB2
> was required, the ++HOLD data would say so
>
> 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.
>
> -----Original Message-----
> From: DB2 Data Base Discussion List
> [mailto:[login to unmask email] On Behalf Of Donna Domovic
> Sent: 09 January 2009 14:24
> To: [login to unmask email]
> Subject: [DB2-L] Is DB2 recycle required when applying
> PTFs?
>
> Hello,
>
> When applying a DB2 PTF to resolve an issue, we've
> always applied the fix to
> the production DB2 loadlib then stopped and restarted DB2.
> The question I
> have is, with the newer versions of DB2 (ie v7, v8, v9,
> etc.) is the DB2 stop
> and start always necessary to pick up the fix? If not, is
> there any way to tell
> when a stop and start is required?
>
> Thanks,
> Donna Domovic
>
>
> ______________________________________________________________________
>
> * 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


______________________________________________________________________

* 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

Listen to 350+ music, sports, & news radio stations FREE while you browse.
Start Listening Now!


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 Melbourne, Australia * 18-20 March * 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