Chapter 23. Locking DB2 Data

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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.