Question: Do you have a quick summary or overview of the different controls Db2 workload manager offers over system resources?
Answer: I do now! :)
Managing resource consumption for multiple databases under the same DB2 instance
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:
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.
This article by Michael Roecken and David Sciaraffa does a deep dive into the recovery and availability enhancements in Db2 V184.108.40.206