REBIND after applying a PTF, what to rebind?

JH

REBIND after applying a PTF, what to rebind?
To list:
I am new to DB2 system programming. I am applying
a PTF UQ80299 (this PTF only an example). the
following is the HOLD DATA.

I know a REBIND is required but not sure which plan or

package should I rebind? Is REBIND(*) a good
practice?
Or should I wait for DB2 to auto rebind, We do have
ABIND=YES.
Thanks for your info.
Joe


++ HOLD(UQ80299) SYS FMID(HDB7710) REASON(DB2BIND)
DATE(03260)
COMMENT

(***Action for PQ77909:



See PQ77909 APAR/PTF text in the PTF cover letter
for
additional information about why a REBIND is
necessary.


PQ77909 corrects a problem of SQLCODE=-401

when the argument of COUNT

is a VARGRAPHIC.



To make this fix effective for a static
application, it must be
rebound after application of this PTF. Review
the PTF cover
letter to determine which, if any, applications
could be
affected by this change.).

++ MOD (DSNXOEXE) DISTLIB(ADSNLOAD)


I know a REBIND is required but not sure which plan or

package should I rebind?



__________________________________
Do you Yahoo!?
Meet the all-new My Yahoo! - Try it today!
http://my.yahoo.com

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Roger Miller

Re: REBIND after applying a PTF, what to rebind?
(in response to JH)
There was a long and spirited discussion of rebinding a couple of months
ago. Where we can, as in this example, we identify the kinds of issues.
You can search the catalog for columns that are VARGRAPHIC. If you have
none, then you don't have the problem.

Customers vary in rebind practice. Some try to avoid binding as much as
possible. Some have tens of thousands of plans and packages. Others have
only a few hundred, and can rebind easily. Some almost never have
problems with rebinds, while others expect a problem every time.

I'd try to avoid using the command REBIND(*), but rather query the catalog
and do individual binds, one set at a time. Find the old plans and get
them rebound, but check for access path changes in the process.

Roger Miller

On Mon, 10 Jan 2005 10:22:26 -0800, Joe Huang <[login to unmask email]> wrote:

>To list:
>I am new to DB2 system programming. I am applying
>a PTF UQ80299 (this PTF only an example). the
>following is the HOLD DATA.
>
>I know a REBIND is required but not sure which plan or
>
>package should I rebind? Is REBIND(*) a good
>practice?
>Or should I wait for DB2 to auto rebind, We do have
>ABIND=YES.
>Thanks for your info.
>Joe
>
>
>++ HOLD(UQ80299) SYS FMID(HDB7710) REASON(DB2BIND)
>DATE(03260)
> COMMENT
>
> (***Action for PQ77909:
>
>
>
> See PQ77909 APAR/PTF text in the PTF cover letter
>for
> additional information about why a REBIND is
>necessary.
>
>
> PQ77909 corrects a problem of SQLCODE=-401
>
> when the argument of COUNT
>
> is a VARGRAPHIC.
>
>
>
> To make this fix effective for a static
>application, it must be
> rebound after application of this PTF. Review
>the PTF cover
> letter to determine which, if any, applications
>could be
> affected by this change.).
>
>++ MOD (DSNXOEXE) DISTLIB(ADSNLOAD)
>
>
>I know a REBIND is required but not sure which plan or
>
>package should I rebind?
>
>

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Tina Hilton

Re: REBIND after applying a PTF, what to rebind?
(in response to Roger Miller)
When I apply PTFs like this, I only rebind programs that experienced this
problem. If you don't have any that (in this case) incorrectly got a -401
sql code, then I wouldn't do anything. DB2 auto-rebind is only when a
package/plan becomes invalid because of a table change or something like
that. It will not cause packages to be rebound for a PTF like this.

Tina Hilton

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of
Joe Huang
Sent: Monday, January 10, 2005 1:22 PM
To: [login to unmask email]
Subject: [DB2-L] REBIND after applying a PTF, what to rebind?

To list:
I am new to DB2 system programming. I am applying
a PTF UQ80299 (this PTF only an example). the
following is the HOLD DATA.

I know a REBIND is required but not sure which plan or

package should I rebind? Is REBIND(*) a good
practice?
Or should I wait for DB2 to auto rebind, We do have
ABIND=YES.
Thanks for your info.
Joe


++ HOLD(UQ80299) SYS FMID(HDB7710) REASON(DB2BIND)
DATE(03260)
COMMENT

(***Action for PQ77909:



See PQ77909 APAR/PTF text in the PTF cover letter
for
additional information about why a REBIND is
necessary.


PQ77909 corrects a problem of SQLCODE=-401

when the argument of COUNT

is a VARGRAPHIC.



To make this fix effective for a static
application, it must be
rebound after application of this PTF. Review
the PTF cover
letter to determine which, if any, applications
could be
affected by this change.).

++ MOD (DSNXOEXE) DISTLIB(ADSNLOAD)


I know a REBIND is required but not sure which plan or

package should I rebind?



__________________________________
Do you Yahoo!?
Meet the all-new My Yahoo! - Try it today!
http://my.yahoo.com

-----------------------------------------------------------------------------
----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm