What is the difference between BIND REPLACE and REBIND commands?

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • sajithamol
    #1

    What is the difference between BIND REPLACE and REBIND commands?

    What is the difference between BIND REPLACE and REBIND commands?
    Tags: None
    • Snib
      New Member
      • Mar 2007
      • 24
      #2
      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

        Comment

        Previous template Next
        Working...