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 ...
Get Understanding DB2®: Learning Visually with Examples, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
