what is the use of bind parameter, Replace?

Answers were Sorted based on User's Feedback



what is the use of bind parameter, Replace?..

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

what is the use of bind parameter, Replace?..

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

what is the use of bind parameter, Replace?..

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

what is the use of bind parameter, Replace?..

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

what is the use of bind parameter, Replace?..

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

Post New Answer

More DB2 Interview Questions

How to compare data between two tables in db2?

0 Answers  


how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE

10 Answers   IBM,


What is alias in db2?

0 Answers  


What are types of indexes?

0 Answers  


Explain about mirror activator disk mirroring?

0 Answers  






What is the picture clause of null indicator variable?

0 Answers  


How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.

3 Answers  


What is host variable in db2 cobol?

0 Answers  


What information is used as input to the bind process?

2 Answers  


what is a collection?

2 Answers  


How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?

2 Answers  


What is DCLGEN?

2 Answers  


Categories