What is concurrency in db2?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Before you give the explain statement, what are the prerogatives?

558


What is bind in db2?

583


What is bind plan?

593


How do I start db2 in windows?

535


What is blu acceleration in db2?

576






before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

1689


What is copy pending and check pending in db2?

557


What do you mean by storage group (stogroup)?

563


What is a storage group (stogroup)?

751


What is the reason behind not using select * in embedded sql programs?

578


What is db2 and what is the use of db2 optimizer?

623


What is isolation level in db2?

559


Mention the different locking levels that are available in db2.

616


What is the maximum size of a char data type in db2?

570


How to find the number of rows in db2 tables?

589