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
Why do we use cursor?
what is the responsibility of the construction superintendent
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What os does db2 run on?
What is the maximum size of varchar data type in db2?
How do you stop a db2 database in linux?
What does reorg do in db2?
Explain in detail about buffer manager and its functionalities?
What is lock escalation in db2?
List down the data types in the db2 database.
How many databases are there?
How to find the number of rows in db2 tables?
What do you mean by between and in? Is between inclusive of specified range values?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What does db2 mean?
