MVSFORUMS.com

[srini_igsi]

Hi,

Can anybody explain me in detail abt the exact diff between 'REPLACE' version of the BIND and REBIND...??

Some where i have read that, if the original SQL statements are changed then, we have to use the 'REPLACE' version of the BIND, where as if the physical structure of the Table/Database is changed then we have to use REBIND.

if somebody can explain me in detail abt the exact diff it will be greatful to me.
_________________
Thanks,
-Srini

[CZerfas]

Hello Srini,

in your question you are mixing multiple concepts. To sort it out, simply read the manual (DB2 V8 Command Reference).

regards
Christian

[a_seshu]

BIND and REBIND are two different animals.

You have ADD and REPLACE options in BIND. If no package with the same userid, same name bound to the same database, as you are BINDing now is present then it will be a BINDADD.

If you have already bound a package to the database and you are now binding a new version of the DBRM (with some SQL changes) it would be a BINDREPLACE.

Say no SQL changes in your DBRM occured but you still need to rebind in some cases when the underlying tables are dropped and recreated or runstats have been run and you want to pick the best accesspath available as of today you can do a REBIND
_________________
I dont think I would ever stop learning. - Seshu.