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:20230326T010000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0200
TZOFFSETTO:+0100
TZNAME:CET
DTSTART:20231029T010000
END:STANDARD
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
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;VALUE=DATE:20241025
DTEND;VALUE=DATE:20241026
DTSTAMP:20260415T141452
CREATED:20241009T220459Z
LAST-MODIFIED:20241128T092315Z
UID:24696-1729814400-1729900799@ubs-hainer.com
SUMMARY:Db2NightShow with Mohan Saraswatipura
DESCRIPTION:UBS Hainer’s Kai Stroh will be a guest on the Db2NightShow with Mohan Saraswatipura for Episode #262: Build a Lightweight Monitor to Identify SQL Workload Tuning Potential \nREGISTER FOR WEBINAR \nOn the podcast\, Kai will talk with Mohan about SQL workloads\, how to build a lightweight monitor to identify workload tuning potential\, and how SQL monitors like SQL Quality Control can help. \n \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. Don’t miss the Db2NightShow!
URL:https://ubs-hainer.com/de/event/db2nightshow-with-mohan-saraswatipura/
LOCATION:Online
CATEGORIES:Podcast
ATTACH;FMTTYPE=image/png:https://ubs-hainer.com/wp-content/uploads/2024/10/mohankumar.saraswatipura.png
END:VEVENT
END:VCALENDAR