[DB2-L] Auto Rebind

Georg Peter

[DB2-L] Auto Rebind
Gwyn,

may be this link can help you:

http://www.idug.org/solutions-journal-content/escaping-the-rebind-blues-
in-db2-9-for-zos.html


With kind regards - mit freundlichen Gruessen,
G e o r g H . P e t e r
-------------------------------------------------------------------
Datenzentrale Baden-Wuerttemberg
Development and Product Support (E3)
Krailenshaldenstrasse 44, 70469 Stuttgart, Germany, Europe
e:mail [login to unmask email]
Phone 0049-711-8108-271
PC-Fax 004971189696071
Internet (only in german language):http://www.dzbw.de
----------------------------------------------------------------------

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * 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 $1600 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 DB2-L

Walter Janißen

AW: [DB2-L] Auto Rebind
(in response to Georg Peter)
Hi

My findings are:

. if an object, the package is depenant of is dropped
. changing column format
. adding a column with datatye DATE, TIME or TIMESTAMP with the clause NOT NULL WITH DEFAULT
. adding a partition, alter limitkey or rotate a partition
. adding a column to an index
. altering an index to PADDED
. adding an RI-relatioship with CASCADE or SET NULL
(packages will be invalidated, which access the parent tables)
. altering a table to a MQT and vice versa
. altering a column, which is referenced by User-Defined Function
. altering a temp. table or a MQT
. altering the AUDIT-attribute
. adding a Security Label
. altering the CCSID of a tablespace
. adding or removing of a VALIDPROC


Mit freundlichen Grüßen
Walter Janissen

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Laufzeitarchitektur
Victoriaplatz 2
40477 Düsseldorf
mailto:[login to unmask email]

Vorsitzender des Aufsichtsrates: Jürgen Vetter
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Ina Kirchhof, Dr. Christian Nymphius, Dr. Michael Regauer, Wolfgang Schön.
Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf, HRB 37996


-----Ursprüngliche Nachricht-----
Von: IDUG DB2-L [mailto:[login to unmask email] Im Auftrag von Gwyn Pritchard
Gesendet: Dienstag, 9. Februar 2010 13:35
An: [login to unmask email]
Betreff: [DB2-L] Auto Rebind

Our Application DBAs have asked me "Under what circumstances will Plans Packages be marked as needing a REBIND". They are particularly interested what effect an ADD COL, Create Index etc , have on their Application.

We are are a zOS shop running DB2 V8 (mainly NF).

SYSPLAN / SYSPACKAGE has a column VALID which will be set to A for Tables which have been altered - I assumed this would always invoke an Auto Rebind at the next execution - but they claim not always and have asked for a definitive list of when it will when it won't..

Apologies if this has been asked before, nothing came up when I did a search.

Kind Regards

Gwyn (DBA)

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * 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 $1600 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 DB2-L

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * 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 $1600 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 DB2-L

David Harvey

Re: AW: [DB2-L] Auto Rebind
(in response to Walter Janißen)
Walter,

A very useful list of possible 'impacts' but for the examples given by Gwyn
("Add col"; "Create index") the simple answer is NO IMPACT.

Mit freundlichen Grüßen und genießen V10 (Bekanntgabe 2 Stunden)

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * 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 $1600 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 DB2-L