Please Release Me – Db2 for z/OS Locking for Application Developers

Understanding Db2 locking is essential to ensure data integrity. This presentation explains Db2 locking semantics and the controls over it, including isolation levels, current data settings and other BIND options.  It exposes the perils of coding your applicationwithout taking Db2 locking behaviour into account. It discusses the concepts of optimistic locking and how to code update applications safely. It explains Db2 lock avoidance, and how applications can be coded to benefit from it, including in a data sharing environment.