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 sqlcode -922 ?

2 Answers  


Can we able to find all the Table names under a Particular Plan?

1 Answers   CTS,


Why db2 is called db2?

0 Answers  


What is a synonym? How is it used?

2 Answers  


Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

0 Answers  


What is the FREE command?

1 Answers  


What does the CHECK Utility do ?

1 Answers  


How can the firstname and the lastname from the emp table be concatenated to generate complete names?

0 Answers  


How to resolve -917 sql code in DB2?

3 Answers   Cap Gemini,


What is the difference between drop table and delete table?

0 Answers  


how do we solve soc 7 and soc4 ?

3 Answers   Tech Mahindra,


How do I optimize a query in db2?

0 Answers  


Categories