Managing resource consumption for multiple databases under the same DB2 instance
Starting in Db2 Version 22.214.171.124, 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 126.96.36.199, 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 V188.8.131.52
Looking for a different way to move data between two databases - check out this article on using LOAD FROM CURSOR with a named pipe.