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/New_York
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
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20270314T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20271107T060000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20260507T110000
DTEND;TZID=America/New_York:20260507T120000
DTSTAMP:20260417T025611
CREATED:20260416T150929Z
LAST-MODIFIED:20260416T151420Z
UID:31494-1778151600-1778155200@ubs-hainer.com
SUMMARY:Which Db2 SQL Is Really Costing You CPU?
DESCRIPTION:In many Db2 environments\, a small number of SQL statements drives a large share of CPU consumption due to suboptimal access paths or missing indexes. Optimizing these workloads is one of the most effective ways to improve response times\, reduce CPU usage\, and lower mainframe costs. The challenge is identifying where optimization will have the greatest impact—and how to achieve measurable results without excessive effort. \nAt the same time\, system-level factors such as DSC thrashing or inefficient buffer pool usage can significantly affect performance and stability. Identifying these issues—and prioritizing them correctly—is often difficult due to limited time and lack of transparency. \nThis webinar shows a structured and practical approach to Db2 performance optimization and how SQLQC supports this process: \n\nWhy a structured approach is effective—from system-level quick wins (e.g.\, DSC thrashing\, buffer pool tuning) to targeted optimization of individual high-impact SQL statements\nHow to quickly identify cost-intensive SQL statements and focus on what really matters\nA live demo demonstrating how a SQL statement can be analyzed and optimized step by step\, including access path analysis\, index recommendations\, and virtual index simulation\nSQLQC’s built-in AI-driven analysis: triggered directly from the statement view\, using collected performance data to provide concrete recommendations for indexes\, RUNSTATS\, and potential query rewrites\n\nLearn how to simplify the work of DBAs and developers\, uncover optimization potential faster\, and translate findings into measurable performance improvements and reduced mainframe costs. \nREGISTER HERE
URL:https://ubs-hainer.com/event/which-db2-sql-is-really-costing-you-cpu/
LOCATION:Online
CATEGORIES:Webinar
ATTACH;FMTTYPE=image/svg+xml:https://ubs-hainer.com/wp-content/uploads/2024/11/event_placeholder_1.svg
END:VEVENT
END:VCALENDAR