Articles & Content

Archives

E14 - Finding Ca$h in the Cache: Leveraging DB2's Dynamic Statement Cache to Save Your Company Money

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2014



Not too long ago, dynamic SQL was something DB2 z/OS DBAs feared. Imagine easing those fears by putting historical dynamic SQL metrics into the capable hands of DBAs. Could you use a TOP 10 report of the worst performing dynamic SQL statements? How about a list of all dynamic SQL that runs against a table? What about reporting dynamic SQL that violates SQL standards? Do you know how to show trends of dynamic SQL activity by application and time period? Once you have the reports, you can begin to save your company big money by tuning what really needs to be tuned! This session will show you how we get the job done at Shelter Insurance.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.