what is the use of bind parameter, Replace?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / mahesh vasudevan
For new packages it will be "ADD" option for an already
existing package...it needs to be replaced with the new DBRM
bound...hence it is REPLACE.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / siri
replace is ACTION parameter of the BIND CARD....in ACTION parameter PACKAGE or PLAN can be addition(ADD) or replacement.....
SYNTAX : ACTION(ADD/REPLACE)
ADD : add the new package to sysibm.syspackage
REPLACE : will replace the an existing package with the same name ,location and collection
REPLVER(version-id) will replace a specific version of an existing package..
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ramanathan
Plan or Package can be an addition or Replacement.
Default is REPLACEMENT.
REPLACE will replace the existing package with the same name, location & collection.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / satty
bind parameter replace is a parameter related to locking
technique. it will specify when to remove the lock.
if any thing wrong please intimate me
Is This Answer Correct ? | 1 Yes | 10 No |
What is cursor with hold option in db2?
pls tell me abt the normalization five types....
What is the physical storage length of time data type?
What is a DB2 bind?
What are the functions of Bind?
What is deadlock?
What is an instance database?
how to check the table is empty or not?
Why select is not preferred in embedded sql programs?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
How do you insert a record with a nullable column?
What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.