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 plan? is plan executable or package?

4 Answers  


What is the difference between spufi and qmf?

0 Answers  


Q3. How will you fetch duplicate values from a DB2 table?

2 Answers   RBS,


What is dclgen (declaration generator)?

0 Answers  


What are the three DB2 date and time data types and their associated functions?

1 Answers  






What is a thread?

3 Answers  


What is db2 catalog database?

0 Answers  


Which component is responsible for db2 startup and shutdown?

0 Answers  


Can you tell me how can you find out the # of rows updated after an update statement?

0 Answers  


when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was

5 Answers   IBM,


What is sqlcode -922 ?

2 Answers  


WHAT IS MEANT BY COMMIT COMMAND?

7 Answers   Wipro,


Categories