Answer Posted / rana
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. 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.
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
How to restart a DB2 program?
What is dclgen in db2?
what is utility for parm lib
Is db2 a mainframe database?
Which is faster delete or truncate?
what is the role of the cursor in db2?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is a db2 schema?
What is meant by dclgen?
What does runstats do in db2?
How to take backup of table in db2?
What is the difference between using bind () and rebind () methods of naming class?
Explain about mirror activator disk mirroring?
Where do you specify them?
Explain about rct.