Auto Rebind

Gwyn Pritchard

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