Chapter 23. Locking DB2 Data

In This Chapter

• How DB2 Manages Locking

• Locks Versus Latches

• Lock Duration

• Table Space Locks

• Table Locks

• Page Locks

• Row Locks

• Lock Suspensions, Timeouts, and Deadlocks

• Partition Independence

• Lock Avoidance

• Data Sharing Global Lock Management

• LOBs and Locking

• DB2 Locking Guidelines

• Other DB2 Components

• The Big Picture

DB2 automatically guarantees the integrity of data by enforcing several locking strategies. These strategies permit multiple users from multiple environments to access and modify data concurrently.

DB2 combines the following strategies to implement an overall locking strategy:

• Table and table space locking

• IRLM page and row locking

• Internal page and row latching

Get DB2 Developer’s Guide: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z/OS, Sixth 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.

Start your free trial