O'Reilly logo

DB2® Universal Database™ v8 Application Development Certification Guide, 2nd Edition by Michael Kyprianou, Steve Sanyal, Kevin Gashyna, David Martineau

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Concurrency Considerations

Database resource control requires the use of data modification rules. There are concurrency anomalies that we will consider when referring to the previous scenario. They include:

  • Lost update

  • Uncommitted read

  • Nonrepeatable read

  • Phantom read

Lost Update Problem

A lost update problem occurs when the same data is changed multiple times when it shouldn't be. The last successful change to the data is kept, and the first change is overwritten. In the previous scenario, PM1 has Jason in his office, discussing project MA2100. He brings up the screen with the project assignments ready to make the update. Meanwhile, PM2 is also discussing the same project with Michael and assigns the project to Michael. PM1's discussion took longer, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required