Availability of data is a must these days. Everything has to be up and running, data outages are becoming few and far between and preferable non-existing. With every release Db2 for z/OS becomes more highly available; however this requires the usage of new features and structures.
Steve Thomas of CA Technologies presents a great introduction into the world of locks, latches, claims and drains. A must see for all developers working wit Db2 for z/OS as well as all DBAs wanting to refresh their knowledge.
Starting in Db2 Version 126.96.36.199, a new feature called 'DB2_AVOID_LOCK_ESCALATION' provides control over lock escalation behaviour. The feature is configured through a dynamic (no instance recycling needed) registry variable:
While system failures seldom happen, most customers expect crash recovery to complete quickly. Our development team decided upon a solution which promised increased availability, without risking the distinguished resilience that Db2 has achieved over the decades.
With the many new features introduced in 188.8.131.52, not to be overlooked are some of the enhancements made in the area of Recovery and Availability.