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
X-WR-CALDESC:Events for UBS Hainer Software
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:America/Chicago
BEGIN:DAYLIGHT
TZOFFSETFROM:-0600
TZOFFSETTO:-0500
TZNAME:CDT
DTSTART:20230312T080000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0500
TZOFFSETTO:-0600
TZNAME:CST
DTSTART:20231105T070000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0600
TZOFFSETTO:-0500
TZNAME:CDT
DTSTART:20240310T080000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0500
TZOFFSETTO:-0600
TZNAME:CST
DTSTART:20241103T070000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0600
TZOFFSETTO:-0500
TZNAME:CDT
DTSTART:20250309T080000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0500
TZOFFSETTO:-0600
TZNAME:CST
DTSTART:20251102T070000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/Chicago:20241029T100000
DTEND;TZID=America/Chicago:20241029T113000
DTSTAMP:20260419T134520
CREATED:20241023T224654Z
LAST-MODIFIED:20241128T092102Z
UID:24751-1730196000-1730201400@ubs-hainer.com
SUMMARY:Alabama Db2 Users Group
DESCRIPTION:Kai Stroh will be a guest speaker at the ADUG meeting giving a talk about SQL workloads\, how to build a lightweight monitor to identify workload tuning potential\, and how SQL monitors like SQL Quality Control can help. \nHe’ll explain how to capture SQL statistics from Db2’s dynamic statement cache and combine them with data from the EXPLAIN tables. \nThe code will even be available for download after the show! \nYou’ll learn to identify which queries benefit most from tuning\, saving time by focusing on high-impact queries. He’ll cover basic metrics like RID list errors and expand to more complex metrics\, including top consumers\, I/O statistics\, and lock contention. He’ll go over SQL monitors and how to track SQL statement performance over time\, enabling you to identify trends. Lastly\, he’ll address detecting access path changes in dynamic SQL workloads\, a common issue. Using historical EXPLAIN data to spot these changes and act quickly\, especially after events like RUNSTATS executions\, which can alter Db2’s access path choices.
URL:https://ubs-hainer.com/event/alabama-db2-users-group/
LOCATION:Online
CATEGORIES:Users Group
ATTACH;FMTTYPE=image/png:https://ubs-hainer.com/wp-content/uploads/2024/11/Alabama_logo.png
END:VEVENT
END:VCALENDAR