Applying lots of PTFs a DB2 system

Keith Gooding

Applying lots of PTFs a DB2 system
Could anyone offer any advice about the best way to apply lots of maintenance to a DB2 system (or point me to some documentation) ?.  I was asked to apply 1 PTF to a z/OS DB2 9.1 system at the GA level but the fix chain involves several hundred PTFs. It is for a test system for an ISV. I decided to get a new DB2 9.1 serverpac from Shopz but now I am not sure how to implement it. Many of the PTFs require rebinds so I assume I cannot escape that action if I upgrade the target libraries. A google search came up with references to doing a 'global rebind' after installing PTFs but I can't find a definition of 'global rebind' anywhere. (I am a z/OS sysprog and my knowledge of DB2 is somewhat limited - I have installed DB2 systems as 'new installs' and have applied individual PTFs but have never upgraded a system)

TIA

Keith




_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-content/index.html has THOUSANDS of free technical presentations!
DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI, Warehouses, - among
many more categories of help waiting for you!
Whether you are an old hand or a DB2 newbie, we have presentations for every level.
_____________________________________________________________________

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

Chris Hoelscher

Re: Applying lots of PTFs a DB2 system
(in response to Keith Gooding)
i can only relate what we do - we apply all RSUs to bring us up to date -
we then install in our TARGET loadlib - when the day comes - we copy
(target) load module to (runtime) load module (iebcopy) - we then bring
the subsystems back up in maint mode - do all required bind syntax changes
and binds (if needed) - and object drop/recreates needed, and then ... we
run a script for the subsystem that creates rebind syntax for ALL packages
(slight syntax variation for trigger packages) and all plans - and then
execute the REBINDS!

Chris Hoelscher
Senior IDMS & DB2 Database Administrator
Humana Inc
502-476-2538
[login to unmask email]

you only need to test the programs that you want to work correctly






From:
Keith Gooding <[login to unmask email]>
To:
[login to unmask email]
Date:
12/21/2009 11:50 AM
Subject:
[DB2-L] Applying lots of PTFs a DB2 system
Sent by:
IDUG DB2-L <[login to unmask email]>



Could anyone offer any advice about the best way to apply lots of
maintenance to a DB2 system (or point me to some documentation) ?. I was
asked to apply 1 PTF to a z/OS DB2 9.1 system at the GA level but the fix
chain involves several hundred PTFs. It is for a test system for an ISV. I
decided to get a new DB2 9.1 serverpac from Shopz but now I am not sure
how to implement it. Many of the PTFs require rebinds so I assume I cannot
escape that action if I upgrade the target libraries. A google search came
up with references to doing a 'global rebind' after installing PTFs but I
can't find a definition of 'global rebind' anywhere. (I am a z/OS sysprog
and my knowledge of DB2 is somewhat limited - I have installed DB2 systems
as 'new installs' and have applied individual PTFs but have never upgraded
a system)

TIA

Keith




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


The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-content/index.html has THOUSANDS of free technical presentations!
DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI, Warehouses, - among
many more categories of help waiting for you!
Whether you are an old hand or a DB2 newbie, we have presentations for every level.
_____________________________________________________________________

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

Cathy Taddei

Re: Applying lots of PTFs a DB2 system
(in response to Chris Hoelscher)
Hi Keith. When faced with long prereq chains, I decide it must be time to do mass maintenance, so I would upgrade to the most recent RSU level. I'm not sure how you would introduce a DB2 serverpac into an environment, as I have never done it. I just do it the old fashioned way, receive all put maintenance there is, do an apply check on all of the RSU sourceid's plus hipers, etc. Chris gave a pretty good sketch of installing into a single subsystem. It's slightly different if you're data sharing.

The system holds are daunting, but you can pretty much ignore hold reason DB2BIND, which state "to make this fix effective you have to rebind the application package". Your DBA's may wish to rebind application packages (the last step in Chris's outline), but that's separate from the maintenance. But you may have to run DSNTIJUZ (reassemble zparms) and run parts of other installation jobs (DSNTIJSG, DSNTIJCC, DXXRBIND, etc.) to drop/recreate system objects and rebind system packages. You may need to rerun the install clist -- there are ways around that, but it helps if you know what you're doing. As I said, I've never done a DB2 serverpac, but I know it won't save you from doing the hold-data tasks. If you have specific questions, you can email me off list.

Regards,
Cathy Taddei
Systems Programmer
PacifiCorp

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Chris Hoelscher
Sent: Monday, December 21, 2009 9:30 AM
To: [login to unmask email]
Subject: Re: [DB2-L] Applying lots of PTFs a DB2 system

i can only relate what we do - we apply all RSUs to bring us up to date - we then install in our TARGET loadlib - when the day comes - we copy (target) load module to (runtime) load module (iebcopy) - we then bring the subsystems back up in maint mode - do all required bind syntax changes and binds (if needed) - and object drop/recreates needed, and then ... we run a script for the subsystem that creates rebind syntax for ALL packages (slight syntax variation for trigger packages) and all plans - and then execute the REBINDS!

Chris Hoelscher
Senior IDMS & DB2 Database Administrator
Humana Inc
502-476-2538
[login to unmask email]

you only need to test the programs that you want to work correctly




From:

Keith Gooding <[login to unmask email]>

To:

[login to unmask email]

Date:

12/21/2009 11:50 AM

Subject:

[DB2-L] Applying lots of PTFs a DB2 system

Sent by:

IDUG DB2-L <[login to unmask email]>


________________________________



Could anyone offer any advice about the best way to apply lots of maintenance to a DB2 system (or point me to some documentation) ?. I was asked to apply 1 PTF to a z/OS DB2 9.1 system at the GA level but the fix chain involves several hundred PTFs. It is for a test system for an ISV. I decided to get a new DB2 9.1 serverpac from Shopz but now I am not sure how to implement it. Many of the PTFs require rebinds so I assume I cannot escape that action if I upgrade the target libraries. A google search came up with references to doing a 'global rebind' after installing PTFs but I can't find a definition of 'global rebind' anywhere. (I am a z/OS sysprog and my knowledge of DB2 is somewhat limited - I have installed DB2 systems as 'new installs' and have applied individual PTFs but have never upgraded a system)

TIA

Keith

________________________________

[cid:_2_0808E9600849C66C00601A2B85257693 ] < http://www.idug.org/ >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >

The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.

________________________________

[ http://www.idug.org/images/M_images/idug%20org.jpg ] < http://www.idug.org >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >

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

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 North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-content/index.html has THOUSANDS of free technical presentations!
DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI, Warehouses, - among
many more categories of help waiting for you!
Whether you are an old hand or a DB2 newbie, we have presentations for every level.
_____________________________________________________________________

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

Bala

Re: Applying lots of PTFs a DB2 system
(in response to Cathy Taddei)
Hello Keith,

We have done a similar exercise at our shop recently but, the DB2 was v7. We
did that ahead of v8 Migration.
What I wanted to do was just apply the Hiper PTFs along with the fallback
PTF.

But, several HIPERs had requirements that made us pull as many as 2000+
PTFs. Our shop is small but, had Pre-PROD and PROD at the
same z/OS LPAR. I ran the APPLY CHECK weeks ahead and analyzed the HOLD DATA
carefully by category.

There were some HOLD Actions that required IPL to take effect. In some
cases, the PTF can take effect later (on IPL date) but, in some
cases it could cause problem. I am DB2 DBA as well so, I knew what are
trivial ones by risk. So, I would advise you work closely with the Database
Administrators of your shop. Because, rebinds at subsystem level could
impact applications and that could come as a surprise to the
DBAs. Anyhow, I guess the DBAs are going to drop/recreate few objects as per
HOLDDATA.

Initially, I planned to selectively rebind. But, ended up rebinding all
packages and plans because, there were some PTFs that fixed the
errors in SQLs involving Views using JOINS, UNIONS etc. If you decide to
rebind all packages, make sure to keep track of packages/plans that
are invalid already. This could help ignore rebind errors.

We took dump of all system files (SMP/E and DB2 system files) ahead of the
exercise and hoped we could restore should there be a serious problem.
Again, we had the SMP/E zones just for the DB2. So, it would
have not affected other products or subsystems. We applied the PTFs to the
target libraries and copied the DSNLOAD to the dataset that is on DB2 Master
job.

This the the challenge a.k.a problem in leaving the system devoid of any
maintenance for long time. If you have the time and if possible you could
group the
PTFs in to more than one chunks and apply them over weekends. That way, you
could better fix if a problem should arise. And, you could ask critical
applications
to be tested along with DBAs right after the apply or copy over.
Regards, Bala.
On Mon, Dec 21, 2009 at 9:55 PM, Keith Gooding <[login to unmask email]> wrote:

> Could anyone offer any advice about the best way to apply lots of
> maintenance to a DB2 system (or point me to some documentation) ?. I was
> asked to apply 1 PTF to a z/OS DB2 9.1 system at the GA level but the fix
> chain involves several hundred PTFs. It is for a test system for an ISV. I
> decided to get a new DB2 9.1 serverpac from Shopz but now I am not sure how
> to implement it. Many of the PTFs require rebinds so I assume I cannot
> escape that action if I upgrade the target libraries. A google search came
> up with references to doing a 'global rebind' after installing PTFs but I
> can't find a definition of 'global rebind' anywhere. (I am a z/OS sysprog
> and my knowledge of DB2 is somewhat limited - I have installed DB2 systems
> as 'new installs' and have applied individual PTFs but have never upgraded a
> system)
>
> TIA
>
> Keith
>
>
> ------------------------------
>
> [image: IDUG - The Worldwide DB2 User Community!] < http://www.idug.org/ >
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are
> not already an IDUG member, please register here. < http://www.idug.org/register >
>

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/solutions-journal.html - home of the IDUG Solutions Journal
Technical atricles from world famous authors in DB2's most prestigious, peer reviewed
magazine now on-line!
_____________________________________________________________________

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

Nenad Vidak

Re: Applying lots of PTFs a DB2 system
(in response to Bala)
Hello,
I've been applying DB2 maintenance and analyzing actions required for years
and from my personal experience dealing with few hundreds of ptfs in a
single apply is not an issue - as Cathy said most of DB2BIND and all DOC
actions can be ignored.( I've never done mass rebind. - that should be done
by DBA responsible for particular application)
At the end you'll come out with the list of 10-20 actions ( jobs ) ...

This is what I usually apply :

APPLY SOURCEID(RSU*,HIPER,PRP)


Regards, Nenad

On Mon, 21 Dec 2009 14:12:59 -0800, Taddei, Cathy
<[login to unmask email]> wrote:

>Hi Keith. When faced with long prereq chains, I decide it must be time to
do mass maintenance, so I would upgrade to the most recent RSU level. I'm
not sure how you would introduce a DB2 serverpac into an environment, as I
have never done it. I just do it the old fashioned way, receive all put
maintenance there is, do an apply check on all of the RSU sourceid's plus
hipers, etc. Chris gave a pretty good sketch of installing into a single
subsystem. It's slightly different if you're data sharing.
>
>The system holds are daunting, but you can pretty much ignore hold reason
DB2BIND, which state "to make this fix effective you have to rebind the
application package". Your DBA's may wish to rebind application packages
(the last step in Chris's outline), but that's separate from the
maintenance. But you may have to run DSNTIJUZ (reassemble zparms) and run
parts of other installation jobs (DSNTIJSG, DSNTIJCC, DXXRBIND, etc.) to
drop/recreate system objects and rebind system packages. You may need to
rerun the install clist -- there are ways around that, but it helps if you
know what you're doing. As I said, I've never done a DB2 serverpac, but I
know it won't save you from doing the hold-data tasks. If you have specific
questions, you can email me off list.
>
>Regards,
>Cathy Taddei
>Systems Programmer
>PacifiCorp
>
>From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Chris Hoelscher
>Sent: Monday, December 21, 2009 9:30 AM
>To: [login to unmask email]
>Subject: Re: [DB2-L] Applying lots of PTFs a DB2 system
>
>i can only relate what we do - we apply all RSUs to bring us up to date -
we then install in our TARGET loadlib - when the day comes - we copy
(target) load module to (runtime) load module (iebcopy) - we then bring the
subsystems back up in maint mode - do all required bind syntax changes and
binds (if needed) - and object drop/recreates needed, and then ... we run a
script for the subsystem that creates rebind syntax for ALL packages (slight
syntax variation for trigger packages) and all plans - and then execute the
REBINDS!
>
>Chris Hoelscher
>Senior IDMS & DB2 Database Administrator
>Humana Inc
>502-476-2538
>[login to unmask email]
>
>you only need to test the programs that you want to work correctly
>
>
>
>
>From:
>
>Keith Gooding <[login to unmask email]>
>
>To:
>
>[login to unmask email]
>
>Date:
>
>12/21/2009 11:50 AM
>
>Subject:
>
>[DB2-L] Applying lots of PTFs a DB2 system
>
>Sent by:
>
>IDUG DB2-L <[login to unmask email]>
>
>
>________________________________
>
>
>
>Could anyone offer any advice about the best way to apply lots of
maintenance to a DB2 system (or point me to some documentation) ?. I was
asked to apply 1 PTF to a z/OS DB2 9.1 system at the GA level but the fix
chain involves several hundred PTFs. It is for a test system for an ISV. I
decided to get a new DB2 9.1 serverpac from Shopz but now I am not sure how
to implement it. Many of the PTFs require rebinds so I assume I cannot
escape that action if I upgrade the target libraries. A google search came
up with references to doing a 'global rebind' after installing PTFs but I
can't find a definition of 'global rebind' anywhere. (I am a z/OS sysprog
and my knowledge of DB2 is somewhat limited - I have installed DB2 systems
as 'new installs' and have applied individual PTFs but have never upgraded a
system)
>
>TIA
>
>Keith
>
>________________________________
>
>[cid:_2_0808E9600849C66C00601A2B85257693 ] < http://www.idug.org/ >
>
>The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are
not already an IDUG member, please register here. < http://www.idug.org/register >
>
>The information transmitted is intended only for the person or entity to
which it is addressed and may contain CONFIDENTIAL material. If you receive
this material/information in error, please contact the sender and delete or
destroy the material/information.
>
>________________________________
>
>[ http://www.idug.org/images/M_images/idug%20org.jpg ] < http://www.idug.org >
>
>The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are
not already an IDUG member, please register here. < http://www.idug.org/register >
>
>------------------------------------------------------------------------------
>
>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 North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
>_____________________________________________________________________
>
>http://www.idug.org/db2-content/index.html has THOUSANDS of free technical
presentations!
>DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI,
Warehouses, - among
>many more categories of help waiting for you!
>Whether you are an old hand or a DB2 newbie, we have presentations for
every level.
>_____________________________________________________________________
>
>If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's DB2-L
>

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/solutions-journal.html - home of the IDUG Solutions Journal
Technical atricles from world famous authors in DB2's most prestigious, peer reviewed
magazine now on-line!
_____________________________________________________________________

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

Keith Gooding

Re: Applying lots of PTFs a DB2 system
(in response to Nenad Vidak)
Thanks to everyone who has replied.I get the message that there is no pain-
free way - I have to read through the hold actions and I need to understand
more of DB2. Some of the replies referred to the 'Database Administrator'.
We have no such person - just anarchic developers with SYSADM authority,
some of whom are very knowledeable about DB2. I will get some
advice/assistance from one of those in the new year.

BTW I still do not know if 'global rebind' is a result of a specific command or
just means rebinding everything.

Keith

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/solutions-journal.html - home of the IDUG Solutions Journal
Technical atricles from world famous authors in DB2's most prestigious, peer reviewed
magazine now on-line!
_____________________________________________________________________

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

Francis Leblanc

Re: Applying lots of PTFs a DB2 system
(in response to Keith Gooding)
'global rebind' just means rebinding everything.

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Keith Gooding
Sent: Tuesday, December 22, 2009 11:23 AM
To: [login to unmask email]
Subject: Re: [DB2-L] Applying lots of PTFs a DB2 system

Thanks to everyone who has replied.I get the message that there is no pain-
free way - I have to read through the hold actions and I need to understand
more of DB2. Some of the replies referred to the 'Database Administrator'.
We have no such person - just anarchic developers with SYSADM authority,
some of whom are very knowledeable about DB2. I will get some
advice/assistance from one of those in the new year.

BTW I still do not know if 'global rebind' is a result of a specific command or
just means rebinding everything.

Keith

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/solutions-journal.html - home of the IDUG Solutions Journal
Technical atricles from world famous authors in DB2's most prestigious, peer reviewed
magazine now on-line!
_____________________________________________________________________

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

This E-Mail has been scanned for viruses.

Gerald Hodge

Re: Applying lots of PTFs a DB2 system
(in response to Francis Leblanc)
Keith:

The way I interpret your question there is no global rebind command, but you could state REBIND *.*. We have seen this done and it can run for very long time. Since you stated this was for an ISV, have you considered creating a new subsystem? We are an ISV and that is what we do with each new version of DB2.

Everyone is correct that the "rebind everything" as a hold action is more observed in the breach than in practice. This does have side effects in a production environment that may not impact an ISV. The usual reasons for requesting a general rebind are changes in the format of entries in SPT01, or methods of execution of static SQL. The SPT01 problem is why IBM is requiring mass and automatic rebinds at specific version levels when migrating version-to-version. Failure to rebind static SQL may cause issues with movement to the EDM POOL for the Skeleton Cursor Table or, even execution issues with 31-bit to 64-bit translations issues and lastly there is always the SPROC performance hit.

If performance measurements are a concern, then rebinding is advisable. Given the size of this work, why not create a new subsystem and then have the DBA / Developers migrate their own work. This would mean anything move to the new subsystem would have to be initial bound and resolve your question.

Gerald Hodge
HLS Technologies, Inc.
www.hlstechnologies.com


-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Keith Gooding
Sent: Tuesday, December 22, 2009 10:23 AM
To: [login to unmask email]
Subject: Re: [DB2-L] Applying lots of PTFs a DB2 system

Thanks to everyone who has replied.I get the message that there is no pain-
free way - I have to read through the hold actions and I need to understand
more of DB2. Some of the replies referred to the 'Database Administrator'.
We have no such person - just anarchic developers with SYSADM authority,
some of whom are very knowledeable about DB2. I will get some
advice/assistance from one of those in the new year.

BTW I still do not know if 'global rebind' is a result of a specific command or
just means rebinding everything.

Keith

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/solutions-journal.html - home of the IDUG Solutions Journal
Technical atricles from world famous authors in DB2's most prestigious, peer reviewed
magazine now on-line!
_____________________________________________________________________

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

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/solutions-journal.html - home of the IDUG Solutions Journal
Technical atricles from world famous authors in DB2's most prestigious, peer reviewed
magazine now on-line!
_____________________________________________________________________

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

Keith Gooding

Re: Applying lots of PTFs a DB2 system
(in response to Gerald Hodge)
Gerald,

Yes, we do create new subsystems for each new version of DB2. But I wanted to upgrade our existing 9.1 subsystem(s) to a more recent maintenance level, specifically to include a particular PTF. I was hoping to do  it quickly and in in a way which did not require any action from the developers.  I think I may do as you suggest and create a new subsystem specifically for the person who needs to test the new function in January and  let the developers decide what to do next.

Keith




________________________________
From: Gerald Hodge <[login to unmask email]>
To: [login to unmask email]
Sent: Tue, 22 December, 2009 16:51:29
Subject: Re: [DB2-L] Applying lots of PTFs a DB2 system

Keith:

The way I interpret your question there is no global rebind command, but you could state REBIND *.*.  We have seen this done and it can run for very long time.  Since you stated this was for an ISV, have you considered creating a new subsystem? We are an ISV and that is what we do with each new version of DB2.

Everyone is correct that the "rebind everything" as a hold action is more observed in the breach than in practice.  This does have side effects in a production environment that may not impact an ISV..  The usual reasons for requesting a general rebind are changes in the format of entries in SPT01, or methods of execution of static SQL.  The SPT01 problem is why IBM is requiring mass and automatic rebinds at specific version levels when migrating version-to-version.  Failure to rebind static SQL may cause issues with movement to the EDM POOL for the Skeleton Cursor Table or, even execution issues with 31-bit to 64-bit translations issues and lastly there is always the SPROC performance hit.

If performance measurements are a concern, then rebinding is advisable.  Given the size of this work, why not create a new subsystem and then have the DBA / Developers migrate their own work. This would mean anything move to the new subsystem would have to be initial bound and resolve your question.

Gerald Hodge
HLS Technologies, Inc.
www.hlstechnologies.com


-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Keith Gooding
Sent: Tuesday, December 22, 2009 10:23 AM
To: [login to unmask email]
Subject: Re: [DB2-L] Applying lots of PTFs a DB2 system

Thanks to everyone who has replied.I get the message that there is no pain-
free way - I have to read through the hold actions and I need to understand
more of DB2. Some of the replies referred to the 'Database Administrator'.
We have no such person - just anarchic developers with SYSADM authority,
some of whom are very knowledeable about DB2. I will get some
advice/assistance from one of those in the new year.

BTW I still do not know if 'global rebind' is a result of a specific command or
just means rebinding everything.

Keith

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 *  http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/solutions-journal.html -  home of the IDUG Solutions Journal
Technical atricles from world famous authors in DB2's most prestigious, peer reviewed
magazine now on-line!
_____________________________________________________________________

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

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 *  http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/solutions-journal.html -  home of the IDUG Solutions Journal
Technical atricles from world famous authors in DB2's most prestigious, peer reviewed
magazine now on-line!
_____________________________________________________________________

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





_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/solutions-journal.html - home of the IDUG Solutions Journal
Technical atricles from world famous authors in DB2's most prestigious, peer reviewed
magazine now on-line!
_____________________________________________________________________

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

Raey

Re: Applying lots of PTFs a DB2 system
(in response to Keith Gooding)
Keith,
 
Global rebind is rebinding all of the packages of a subsystem. In my shop, I do not do global rebind after applying fixes because my team does not know how often  reorg and runstats job execute against the DB2 objects.  If the DB2 objects have old statstics, doing rebind by itself my cause access path changes.

AK

--- On Mon, 12/21/09, Keith Gooding <[login to unmask email]> wrote:


From: Keith Gooding <[login to unmask email]>
Subject: [DB2-L] Applying lots of PTFs a DB2 system
To: [login to unmask email]
Date: Monday, December 21, 2009, 10:25 AM






Could anyone offer any advice about the best way to apply lots of maintenance to a DB2 system (or point me to some documentation) ?.  I was asked to apply 1 PTF to a z/OS DB2 9.1 system at the GA level but the fix chain involves several hundred PTFs. It is for a test system for an ISV. I decided to get a new DB2 9.1 serverpac from Shopz but now I am not sure how to implement it. Many of the PTFs require rebinds so I assume I cannot escape that action if I upgrade the target libraries. A google search came up with references to doing a 'global rebind' after installing PTFs but I can't find a definition of 'global rebind' anywhere. (I am a z/OS sysprog and my knowledge of DB2 is somewhat limited - I have installed DB2 systems as 'new installs' and have applied individual PTFs but have never upgraded a system)
 
TIA
 
Keith





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 * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups,
there is probably one near you!
Regional User Groups are your local connection to the Worldwide DB2 User Community
_____________________________________________________________________

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

Max Scarpa

Re: Applying lots of PTFs a DB2 system
(in response to Raey)
I applied in the past some hundreds PTFs in 'one shot' (I think once they
twere 620) + some PTFs for z/Os (for LOBs if I remember well) and I had no
problem, apart nuisance to check actions but with appropriate SMP/E
options it can be easy. Sometimes some PTFs are SUPed by others so the
number could decrease at the very end. Problems could happen if you have
PTFs requesting IPL or DB2 restart.

As said BIND can be bypassed most of time, but it'd be checked why a
BIND/REBIND is requested. I've never done a global rebind for PTFs, only
for DB2 migrations.

Max Scarpa


_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups,
there is probably one near you!
Regional User Groups are your local connection to the Worldwide DB2 User Community
_____________________________________________________________________

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

Cuneyt Goksu

Re: Applying lots of PTFs a DB2 system
(in response to Max Scarpa)
Lately we had applied 1500+ PTFs for a V8 system to be ready for V9
preperation.

It was tough but it worked...

Cuneyt

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Max Scarpa
Sent: Tuesday, December 29, 2009 6:19 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Applying lots of PTFs a DB2 system



I applied in the past some hundreds PTFs in 'one shot' (I think once
they twere 620) + some PTFs for z/Os (for LOBs if I remember well) and I
had no problem, apart nuisance to check actions but with appropriate
SMP/E options it can be easy. Sometimes some PTFs are SUPed by others so
the number could decrease at the very end. Problems could happen if you
have PTFs requesting IPL or DB2 restart.

As said BIND can be bypassed most of time, but it'd be checked why a
BIND/REBIND is requested. I've never done a global rebind for PTFs, only
for DB2 migrations.

Max Scarpa



_____


< http://www.idug.org > IDUG - The Worldwide DB2 User Community!

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please < http://www.idug.org/register >
register here.


_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.IDUG.org membership is now free.
Do you have people in your office who are not an IDUG member?
Show them how to access the information and help train the next generation of DB2 Users!
_____________________________________________________________________

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

Max Scarpa

Re: Applying lots of PTFs a DB2 system
(in response to Cuneyt Goksu)
Ehi I'm only a normal DB2 sysprog (if PTFs < 1000 then LABEL='normal
sysprog') , that's why IBM datachampions exist ;-)))))

Kidding of course.....Ciao Cuneyt.

Max Scarpa

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.IDUG.org membership is now free.
Do you have people in your office who are not an IDUG member?
Show them how to access the information and help train the next generation of DB2 Users!
_____________________________________________________________________

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