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

how to take the back up of the DB2 table.

7 Answers  


What is a synonym? How is it used?

2 Answers  


What is PRIME TABLE and what are the uses of it

1 Answers  


What are some characteristics of columns that benefit from indexes?

1 Answers  


Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.

1 Answers  






When is the access path determined for dynamic SQL?

2 Answers  


How could one combine a set of incremental image copies into a single copy?

1 Answers  


What is role in db2?

0 Answers  


db2 restart logic ?

1 Answers   DELL, HTC, UHG,


Is ibm db2 free?

0 Answers  


what are bind concepts in db2 cobol?

0 Answers  


What is correlation names?

1 Answers  


Categories