BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//UBS Hainer Software - ECPv6.15.19//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:UBS Hainer Software
X-ORIGINAL-URL:https://ubs-hainer.com/de/
X-WR-CALDESC:Veranstaltungen für UBS Hainer Software
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:America/New_York
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20240310T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20241103T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20250309T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20251102T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20260308T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20261101T060000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;VALUE=DATE:20250608
DTEND;VALUE=DATE:20250613
DTSTAMP:20260413T211350
CREATED:20250520T202927Z
LAST-MODIFIED:20250606T102333Z
UID:28773-1749340800-1749772799@ubs-hainer.com
SUMMARY:IDUG NA 2025
DESCRIPTION: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! \nJoin 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. \nKey Takeaways include: \n\n\nLearn to capture SQL statistics from Db2’s dynamic statement cache \n\n\nCombine dynamic cache data with EXPLAIN table information \n\n\nIdentify which queries offer the greatest potential for tuning \n\n\nStart with simple metrics such as RID list errors and progress to advanced performance indicators (top consumers\, I/O statistics\, lock contention\, and more) \n\n\nTrack performance and resource consumption of specific SQL statements over time to spot trends \n\n\nDetect access path changes in dynamic SQL workloads \n\n\nUnderstand how routine operations (like RUNSTATS) can lead to unexpected access path changes \n\n\nUse historic EXPLAIN data to quickly identify and address access path issues \n\n\nNote:\nAll code demonstrated in the session will be available for download after the event. \n 
URL:https://ubs-hainer.com/de/event/idug-na-2025/
LOCATION:Hyatt Regency Atlanta\, 265 Peachtree Street\, Atlanta\, GA\, 30303\, United States
CATEGORIES:Conference
ATTACH;FMTTYPE=image/png:https://ubs-hainer.com/wp-content/uploads/2025/05/idug_logo.png
END:VEVENT
END:VCALENDAR