What is concurrency in db2?



What is concurrency in db2?..

Answer / vasuki🐍

Concurrency is the ability of more than one application process to access the same data at essentially the same time.
However, DB2 use locks to control concurrency to prevent lost updates and such possibly undesirable effects as unrepeatable reads and access to uncommitted data.
locks ensure that no process accesses data that has been changed, but not yet committed,

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is rebind in db2?

0 Answers  


What Utility is used to migrate DB2 from one release to the next?

1 Answers  


Can we insert update delete in view?

0 Answers  


What will the FREE command do to a plan?

2 Answers  


Which components manage deadlocks in db2?

0 Answers  






My sql statement select avg(salary) from emp yields inaccurate results. Why?

0 Answers  


db2 restart logic ?

1 Answers   DELL, HTC, UHG,


What are bind parameters in db2?

0 Answers  


How can you split a table in to exactly half?

7 Answers   HSBC,


What is meant by union and union all?

0 Answers  


What is the difference between a package and a plan?

6 Answers   Infosys, L&T, Mphasis,


What is db2 look?

0 Answers  


Categories