Dynamic plan stability

Db2 12 introduces the capability to achieve access path stability comparable to static SQL statements for repeating cached dynamic SQL statements.

When you enable dynamic SQL plan stability, Db2 stores statement cache structures for specified dynamic SQL statements in the Db2 catalog. Whenever a stabilized dynamic SQL statement is not present in the dynamic statement cache when issued, Db2 can load the statement cache structures from the Db2 catalog and avoid the full prepare operation.