Here are three top concurrency problems in DB2. So DB2 use locking mechanism to avoid these.
DB2 Concurrency Problems
- Lost updates- Two processes A and B Accessing same row. A is updated the row, and then B also updates the same row. So A ‘s updates are lost.
- Dirty Read – Accessing data which is not committed
- Unrepeatable read- without concurrency causes you to get different data each time you read.
Because of all the above reasons, DB2 apply Locks on the resources.
Related Posts
LATEST POSTS
How to Write Echo Command Correctly in Linux
Here are ideas to write Echo command in Linux shell script.
Linux Sed Command: Way to Get Match Criteria
This topic shows to use the sed command in Linux to get a matching string
How to add Boolean Operators in MySQL Query
An example SQL query that works in MySQL shows how to use Boolean Operators in the WHERE clause.
SQL Count Vs Count Distinct With Group By
Explained how to get records using COUNT and COUNT Distinct with Group By clause in SQL
Loading…
Something went wrong. Please refresh the page and/or try again.
Srinimf 