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
JCL MSGCLASS Vs. MSGLEVEL Top Differences
The MSGCLASS and MSGLEVEL control the print of messages to the output listing. Here are the detailed meanings and default values.
20 Software Engineer Gift Ideas: From Gadgets to Games
Here are the top gift ideas for software developers that you can buy online for their marriages, birthdays, and other special occasions.
Web 3.0 Key Properties that Improve User Satisfaction
Here are the essential properties of Web 3.0 and how it helps the user improve web usage satisfaction.
Windows Task Scheduler: Techniques to Create BAT File
Here’s a step-by-step guide for creating a task in the Windows task scheduler and adding a BAT file with the extension .bat.
Loading…
Something went wrong. Please refresh the page and/or try again.
Srinimf 