Discovered in my dusty email archives, information for an undocumented feature from 2009 to provide a server-side mechanism to manipulate the default isolation level for connections issuing dynamic SQL...
In this article we are going to examine some tuning options that a DBA has available to help improve dynamic SQL performance on DB2 LUW.
With more and more of today’s applications using dynamic SQL, having the option to retain a good access path and avoid prepares is important to maintain good, consistent performance. Dynamic Plan Stability is a major new capability and a key reason for looking forward to DB2 12 and early adaptation
This video is a presentation given at the IDUG DB2 North America Tech Conference in May 2015. It begins with Adrian Burke discussing the challenges associated with tuning dynamic SQL. Then Saghi Amirsoleymani comes in to discuss the features in the no-charge version of IBM Data Studio.