Understanding DB2: Learning Visually with Examples (2nd Edition)

11.1. DB2 Locking and Concurrency: The Big Picture

Figure 11.1 provides an overview of the DB2 locking mechanism using isolation levels. Isolation levels can be configured by various methods. Depending on the isolation level specified, DB2 performs database locking differently. The following sections discuss these in more detail.