O'Reilly logo

Understanding DB2®: Learning Visually with Examples, Second Edition by Dwaine R. Snow, Michael Dang, Xiaomei Wang, Raul F. Chong

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

Chapter 12. Understanding Concurrency and Locking

You need to establish or define some rules and locking semantics to guarantee data integrity in case more than one user tries to update the same row of data in a multi-user database environment. DB2 uses four isolation levels to support different levels of concurrency. Each isolation level is implemented by slightly different locking behaviors. In this chapter we will look at their differences and some examples of how they can be used in the application. As a database administrator or an application developer you will find it very helpful to know troubleshooting skills to identify locking problems, and this chapter covers DB2 monitoring tools to do this.

In this chapter you will learn about:

  • The ...

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