467,170 Members | 1,110 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,170 developers. It's quick & easy.

What is the difference between BIND REPLACE and REBIND commands?

What is the difference between BIND REPLACE and REBIND commands?
Jun 25 '07 #1
  • viewed: 12520
Share:
1 Reply
A "BIND REPLACE" will require a DBRM as input and will replace the existing data with that supplied in the DBRM. It will then analyse the access paths for the SQL supplied in the DBRM.

A "REBIND" re-calculates the access paths for the existing SQL data in DB2. It does not take a DBRM as input as it is using the existing DBRM data loaded by a prior BIND statement.

You tend to run a "BIND REPLACE" when the associated application has been updated so that DB2 is also updated with any changes to the SQL. You tend to run "REBIND" statements as part of the maintenance process for the database in conjunction with RE-ORG and RUNSTAT execution to ensure the SQL is always using the most efficient access paths to the data.

Regards

Snib
Jun 30 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

220 posts views Thread by Brandon J. Van Every | last post: by
4 posts views Thread by marek zegarek | last post: by
reply views Thread by rattas | last post: by
2 posts views Thread by Ben.Combrink@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.