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

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

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!

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, is the home of IDUG's DB2-L