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
The MSGCLASS and MSGLEVEL control the print of messages to the output listing. Here are the detailed meanings and default values.
Here are the top gift ideas for software developers that you can buy online for their marriages, birthdays, and other special occasions.
by Srini
March 25, 2023 March 25, 2023
Here are the essential properties of Web 3.0 and how it helps the user improve web usage satisfaction.
by Srini
March 19, 2023 March 22, 2023
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.
by Srini
March 18, 2023 March 17, 2023
Load more posts
Loading…
Something went wrong. Please refresh the page and/or try again.
Like this: Like Loading...