UBS Hainer will be in Atlanta for IDUG North America 2025 which officially opens on Sunday, June 8, and concludes on Thursday, June 12 If you go, be sure to stop by our booth and say!

Join Kai Stroh’s presentation on Thursday, June 12 at 9 AM. “Build a lightweight monitor to identify SQL workload tuning potential”, a practical session on harnessing SQL statistics from Db2’s dynamic statement cache and integrating them with your EXPLAIN tables. Learn how to pinpoint the queries that will benefit most from tuning, so you can maximize your performance efforts where they matter most. All code used during the session will be available for download afterward.

Key Takeaways include:

• Learn to capture SQL statistics from Db2’s dynamic statement cache

• Combine dynamic cache data with EXPLAIN table information

• Identify which queries offer the greatest potential for tuning

• Start with simple metrics such as RID list errors and progress to advanced performance indicators (top consumers, I/O statistics, lock contention, and more)

• Track performance and resource consumption of specific SQL statements over time to spot trends

• Detect access path changes in dynamic SQL workloads

• Understand how routine operations (like RUNSTATS) can lead to unexpected access path changes

• Use historic EXPLAIN data to quickly identify and address access path issues

Note:
All code demonstrated in the session will be available for download after the event.