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 does the sqlcode of -818 pertain to?

3 Answers  


When Can you be sure that a query will return only one row?

4 Answers   IBM,


How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?

6 Answers   Wipro,


How to rename a table in DB2 ?

0 Answers   MCN Solutions,


Can we delete records from view?

0 Answers  


What is syscat in db2?

0 Answers  


Explain the EXPLAIN statement?

1 Answers  


List out the buffer pools in db2

0 Answers  


What is the advantage in De-normalizing tables in DB2?

0 Answers  


When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?

2 Answers  


can you use symbolic parameters in JOB?

5 Answers   IBM,


How to create db2 table in mainframe?

0 Answers  


Categories