A Beginners guide to Locks, Latches, Claims and Drains in DB2 for z/OS

Monday, 12 June, 2017 - 15:00 - 16:00
z/OS Track
Steve Thomas
This session will provide an introduction to how data integrity is achieved within DB2 for z/OS by a variety of methods including Locks, Latches, Claims and Drains. Once you understand how this works we will describe how you can use this knowledge to improve performance and data availability in your applications while maintaining data integrity.
While being an important topic for all users of DB2, the session is primarily aimed at Application Developers and others who may not have been exposed to the detailed internals of DB2 operations. The intention is to explain how Locking works in simple terms and describe how you can exploit this without confusing you with all the gory details of the internals.


SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us



Events in 2021

VIRTUAL EVENT - 27th - 28th May 2021