By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,004 Members | 1,296 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,004 IT Pros & Developers. It's quick & easy.

What is the difference between BIND REPLACE and REBIND commands?

P: n/a
What is the difference between BIND REPLACE and REBIND commands?
Jun 25 '07 #1
Share this Question
Share on Google+
1 Reply


P: 24
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.