Db2 11.5 is here and with it comes a bunch of new features and changed behaviors in the area of Availability & Recovery that should make your every day tasks easier. Check out the list that includes items like Advanced Log Space Management, Reduced Logging and better HADR Reads on Standby.
Thinking about your availability and recovery strategy shouldn't give you sleepless nights. Db2 understands the importance of keeping your database online 24x7 and with Db2 11.1 / 11.5 and its continuous delivery of new features and enhancements, you are on the right path of achieving such goals.
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.
This article by Michael Roecken and David Sciaraffa does a deep dive into the recovery and availability enhancements in Db2 V188.8.131.52