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
What is the difference between db2 and oracle?
What are db2 tables?
How is a typical db2 batch pgm executed?
What is dbrm? What it contains? When it will be created?
What is phantom read in db2?
How to check table size in db2 sap?
What do you mean by commit and rollback?
What is the max length of sqlca?
What is cursor with hold option in db2?
Which command is used to connect to a database in DB2 ? Give the Syntax.
Which component is responsible for db2 startup and shutdown?
What is the maximum length of sqlca?
How do I start db2 in windows?
Explain package in db2 and its advantages?
What does reorg do in db2?