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.