Close X

Top tips to improve the Performance of Dynamic SQL


Presentation

In the early days of DB2 for z/OS the use of dynamic SQL was minimized at most DB2 installations due to fears over unreliable or unpredictable performance. That approach has been almost completely turned on its head now and it is common to find sites where the vast majority of application SQL is Dynamic rather than Static in nature. There are many reasons for this change, including the increasing use of languages such as Java rather than traditional COBOL and PL/I as well as Dynamic based Packaged Applications such as SAP. However, in order to support this gradual change over the years DB2 has also added many features to allow better Performance as well as Management of Dynamic SQL. Many don’t require application changes to allow you to exploit them, but others do and relatively minor changes in coding practice can produce significant benefits. This presentation will describe a variety of methods to improve the performance of Dynamic SQL and provide useful tips on how to best exploit them. Topics covered include using the Local and Global Statement Cache as well as the new Dynamic Plan Stability feature added in DB2 12 for z/OS and more.

 

(IK)

Stream: DB2
Room: Monza
Time: 15:15 - 16:15

Attachments

GSE17 IK.pdf

Speakers


  • Steve Thomas at CA Technologies
  • Steve is a Principal Engineering Services Architect at CA Technologies, reporting into R&D. This role involves helping to influence future product strategy and working with customers to ensure they get the most value out of their investment with CA. Steve has been a DB2 Specialist for over 25 years, an IBM Champion for Analytics since 2009 and is a regular speaker at User Groups and events around the globe. He has been a member of the Conference Planning Committee for IDUG EMEA for over 10 years and was honoured to serve as Chairman of the 2015 event in Dublin.


    Email: steve.thomas@ca.com

  • Steve Thomas at CA Technologies
  • Steve is a Principal Engineering Services Architect at CA Technologies, reporting into R&D. This role involves helping to influence future product strategy and working with customers to ensure they get the most value out of their investment with CA. Steve has been a DB2 Specialist for over 25 years, an IBM Champion for Analytics since 2009 and is a regular speaker at User Groups and events around the globe. He has been a member of the Conference Planning Committee for IDUG EMEA for over 10 years and was honoured to serve as Chairman of the 2015 event in Dublin.


    Email: steve.thomas@ca.com

    Feedback

    Click here to give some Feedback so we can make it even better next year!