Is DB2 recycle required when applying PTFs?

Donna Domovic

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

Phil Grainger

Re: Is DB2 recycle required when applying PTFs?
(in response to Donna Domovic)
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

Edward Long

Re: Is DB2 recycle required when applying PTFs?
(in response to Phil Grainger)
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

James Campbell

Re: Is DB2 recycle required when applying PTFs?
(in response to Edward Long)
I have seen maintenance on Utilities where the ++HOLD has said that it
won't take effect until DB2 is cycled. I think this is because utility processing
depends on modules on both the client side (DSNUTILB) and DBM1 side,
so in a data sharing situation you might have the utility behaving in the old
way when connected to one member, but in the new way when connected to
another.

In general - recycle unless you know you don't need to.

James Campbell

On 9 Jan 2009 at 9:50, Ed Long wrote:

> 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 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