I have a question about the total_extended_latch_wait_time monitor element. We recently saw high values of total_extended_latch_wait_time and we'd like to understand how to interpret this.
A database lock is a mechanism utilized by Db2 to govern the access to a database object amongst different transactions. This article describes the locking mechanism for Db2 (for LUW).
Locking and latching are both key mechanisms employed by relational database management systems to ensure data integrity, consistency, and the serialization of resources. In the Db2 for z/OS IRLM manages the locks, but both Db2 and IRLM have internal latches.