Starting in Db2 Version 184.108.40.206, 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 220.127.116.11, not to be overlooked are some of the enhancements made in the area of Recovery and Availability.
It's inevitable that you see a couple of DB2 fix packs every year and place the readme document in a drawer somewhere for perusal later when you are not busy. While the fix packs may contain fixes there are sometimes a few enhancements buried in the fine print.
DB2 11.1 for LUW introduced built-in SQL functions for regular expressions, a long-awaited enhancement that effectively supersedes a couple of popular workarounds for regex processing in DB2 SQL. This article describes the REGEXP functions and explains what makes them better than older workarounds.