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
Exclusive Loops Vs Iterator Object in Python
Loops and iterators are two unique concepts. But the outcome is the same. Here are details explained with simple examples.
Bash Script Simplified – How to Read Array and Print
Here’s a simplified script to read all the elements of the array. You can do two things with this script. Those are appending and Counting.
Ubuntu – Top Command to Change Default Shell
Here’s a simple command that you can use to change shells. It’s useful to work with multiple shells at a time.
How to Resolve -206 SQL Error Object-Not-Valid in DB2
Here is a resolution for SQL error -206. You will get an error of object is not valid. Here are possible reasons for this error. Also given solution for how to fix it.
Loading…
Something went wrong. Please refresh the page and/or try again.
