You have probably heard about Db2 12 Dynamic SQL plan stability already. However, before you decide to activate it, you should learn more first. This article is going to help you on your journey to stabilize your dynamic world.
Dynamic SQL statements can remain in the dynamic statement cache for a long period of time. When the statement gets refreshed, its access path could change dramatically. This article shows one way of limiting the impact of such an access path shift.
This article sheds a little light on the inner workings of dynamic workload balancing of distributed connections, and how this can benefit the performance, scalability and availability of your DB2 for z/OS solutions.