Chapter 11. Understanding Concurrency and Locking
You need to establish some rules and locking mechanisms 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 behavior. In this chapter we will look at their differences and some examples on how they can be used in the application. As a database administrator or an application developer it is 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 big picture of the ...
Get Understanding DB2®: Learning Visually with Examples 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.
