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:Europe/Berlin
BEGIN:DAYLIGHT
TZOFFSETFROM:+0100
TZOFFSETTO:+0200
TZNAME:CEST
DTSTART:20240331T010000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0200
TZOFFSETTO:+0100
TZNAME:CET
DTSTART:20241027T010000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:+0100
TZOFFSETTO:+0200
TZNAME:CEST
DTSTART:20250330T010000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0200
TZOFFSETTO:+0100
TZNAME:CET
DTSTART:20251026T010000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:+0100
TZOFFSETTO:+0200
TZNAME:CEST
DTSTART:20260329T010000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0200
TZOFFSETTO:+0100
TZNAME:CET
DTSTART:20261025T010000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;VALUE=DATE:20251026
DTEND;VALUE=DATE:20251031
DTSTAMP:20260413T193651
CREATED:20250606T102129Z
LAST-MODIFIED:20250807T114611Z
UID:28838-1761436800-1761868799@ubs-hainer.com
SUMMARY:IDUG EMEA 2025
DESCRIPTION:UBS Hainer will be in Düsseldorf for IDUG EMEA 2025 which officially opens on Sunday\, October 26\, and concludes on Thursday\, October 30. \nJoin Kai Stroh’s presentation on Monday\, October 27 at 4:30 PM. “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-emea-2025/
LOCATION:Hilton Dusseldorf\, Germany
CATEGORIES:Conference
ATTACH;FMTTYPE=image/png:https://ubs-hainer.com/wp-content/uploads/2025/05/idug_logo.png
END:VEVENT
END:VCALENDAR