{"id":24751,"global_id":"ubs-hainer.com\/de\/?id=24751","global_id_lineage":["ubs-hainer.com\/de\/?id=24751"],"author":"18","status":"publish","date":"2024-10-24 00:46:54","date_utc":"2024-10-23 22:46:54","modified":"2024-11-28 10:21:02","modified_utc":"2024-11-28 09:21:02","url":"https:\/\/ubs-hainer.com\/de\/event\/alabama-db2-users-group\/","rest_url":"https:\/\/ubs-hainer.com\/de\/wp-json\/tribe\/events\/v1\/events\/24751","title":"Alabama Db2 Users Group","description":"<p>Kai Stroh will be a guest speaker at the <a href=\"http:\/\/www.alabamadb2usersgroup.org\/\">ADUG<\/a> meeting giving a talk about SQL workloads, how to build a lightweight monitor to identify workload tuning potential, and how SQL monitors like <a href=\"https:\/\/ubs-hainer.com\/product\/sqlqc\/\">SQL Quality Control<\/a> can help.<\/p>\n<p>He\u2019ll explain how to capture SQL statistics from Db2\u2019s dynamic statement cache and combine them with data from the EXPLAIN tables.<\/p>\n<p><strong>The code will even be available for download after the show!<\/strong><\/p>\n<p>You\u2019ll learn to identify which queries benefit most from tuning, saving time by focusing on high-impact queries. He\u2019ll cover basic metrics like RID list errors and expand to more complex metrics, including top consumers, I\/O statistics, and lock contention. He\u2019ll go over SQL monitors and how to track SQL statement performance over time, enabling you to identify trends. Lastly, he\u2019ll 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\u2019s access path choices.<\/p>","excerpt":"","slug":"alabama-db2-users-group","image":{"url":"https:\/\/ubs-hainer.com\/wp-content\/uploads\/2024\/11\/Alabama_logo.png","id":25241,"extension":"png","width":300,"height":111,"filesize":13181,"sizes":{"thumbnail":{"width":150,"height":56,"mime-type":"image\/png","filesize":3960,"url":"https:\/\/ubs-hainer.com\/wp-content\/uploads\/2024\/11\/Alabama_logo-150x56.png"}}},"all_day":false,"start_date":"2024-10-29 10:00:00","start_date_details":{"year":"2024","month":"10","day":"29","hour":"10","minutes":"00","seconds":"00"},"end_date":"2024-10-29 11:30:00","end_date_details":{"year":"2024","month":"10","day":"29","hour":"11","minutes":"30","seconds":"00"},"utc_start_date":"2024-10-29 15:00:00","utc_start_date_details":{"year":"2024","month":"10","day":"29","hour":"15","minutes":"00","seconds":"00"},"utc_end_date":"2024-10-29 16:30:00","utc_end_date_details":{"year":"2024","month":"10","day":"29","hour":"16","minutes":"30","seconds":"00"},"timezone":"UTC-6","timezone_abbr":"UTC-6","cost":"","cost_details":{"currency_symbol":"$","currency_code":"USD","currency_position":"prefix","values":[]},"website":"http:\/\/www.alabamadb2usersgroup.org\/","show_map":true,"show_map_link":true,"hide_from_listings":false,"sticky":false,"featured":false,"categories":[{"name":"Users Group","slug":"users-group","term_group":0,"term_taxonomy_id":86,"taxonomy":"tribe_events_cat","description":"","parent":0,"count":1,"filter":"raw","term_order":"0","id":86,"urls":{"self":"https:\/\/ubs-hainer.com\/de\/wp-json\/tribe\/events\/v1\/categories\/86","collection":"https:\/\/ubs-hainer.com\/de\/wp-json\/tribe\/events\/v1\/categories"}}],"tags":[],"venue":{"id":17198,"author":"18","status":"publish","date":"2021-12-20 13:42:27","date_utc":"2021-12-20 12:42:27","modified":"2023-03-07 02:12:54","modified_utc":"2023-03-07 01:12:54","url":"https:\/\/ubs-hainer.com\/de\/veranstaltungsort\/online\/","venue":"Online","slug":"online","json_ld":{"@type":"Place","name":"Online","description":"","url":"","address":{"@type":"PostalAddress"},"telephone":"","sameAs":""},"show_map":false,"show_map_link":false,"global_id":"ubs-hainer.com\/de\/?id=17198","global_id_lineage":["ubs-hainer.com\/de\/?id=17198"]},"organizer":[{"id":21305,"author":"18","status":"publish","date":"2023-04-21 13:26:39","date_utc":"2023-04-21 11:26:39","modified":"2023-04-21 13:26:39","modified_utc":"2023-04-21 11:26:39","url":"https:\/\/ubs-hainer.com\/de\/veranstalter\/idug\/","organizer":"IDUG","slug":"idug","website":"https:\/\/www.idug.org","json_ld":{"@type":"Person","name":"IDUG","description":"","url":"https:\/\/www.idug.org","telephone":"","email":"","sameAs":"https:\/\/www.idug.org"},"global_id":"ubs-hainer.com\/de\/?id=21305","global_id_lineage":["ubs-hainer.com\/de\/?id=21305"]}],"custom_fields":[],"json_ld":{"@context":"http:\/\/schema.org","@type":"Event","name":"Alabama Db2 Users Group","description":"&lt;p&gt;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 [&hellip;]&lt;\/p&gt;\\n","image":"https:\/\/ubs-hainer.com\/wp-content\/uploads\/2024\/11\/Alabama_logo.png","url":"https:\/\/ubs-hainer.com\/de\/event\/alabama-db2-users-group\/","eventAttendanceMode":"https:\/\/schema.org\/OfflineEventAttendanceMode","eventStatus":"https:\/\/schema.org\/EventScheduled","startDate":"2024-10-29T10:00:00-06:00","endDate":"2024-10-29T11:30:00-06:00","location":{"@type":"Place","name":"Online","description":"","url":"","address":{"@type":"PostalAddress"},"telephone":"","sameAs":""},"organizer":{"@type":"Person","name":"IDUG","description":"","url":"https:\/\/www.idug.org","telephone":"","email":"","sameAs":"https:\/\/www.idug.org"},"performer":"Organization"}}