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
Before you give the explain statement, what are the prerogatives?
What is bind in db2?
What is bind plan?
How do I start db2 in windows?
What is blu acceleration in db2?
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 ?
What is copy pending and check pending in db2?
What do you mean by storage group (stogroup)?
What is a storage group (stogroup)?
What is the reason behind not using select * in embedded sql programs?
What is db2 and what is the use of db2 optimizer?
What is isolation level in db2?
Mention the different locking levels that are available in db2.
What is the maximum size of a char data type in db2?
How to find the number of rows in db2 tables?