NEDB2UG RUG goto meetingSep 26, 2024, 8:00 AM – 1:00 PM (America/New_York)
Please join my meeting from your computer, tablet or smartphone.
https://meet.goto.com/597208445
GO TO Meeting
Session title: Build a lightweight monitor to identify SQL workload tuning potential - Kai Stroh UBS Hainer
ABSTRACT:
Build a lightweight monitor to identify SQL workload tuning potential
In this session, you will learn how to capture SQL statistics from Db2’s dynamic
statement cache and how to combine them with the information from your EXPLAIN
tables. The code that we use will be available for download after the session.
Discover how to identify the queries that will benefit most from tuning, allowing you to
focus your valuable time on those that matter.
We start with simple metrics like RID list errors and work our way up to other
performance metrics like top consumers, I/O statistics, lock contention, and more. You
will learn how to track the performance and resource consumption of a given SQL
statement over time, which makes it possible to spot trends.
Finally, we will show how to detect access path changes in dynamic SQL workload. This
is a common problem in environments with heavy dynamic workload. Something as
simple as a single RUNSTATS execution on one of the involved tables can cause
unexpected changes to the access path that Db2 chooses. Using historic explain
information, these changes become visible, and you can take immediate action.
Speaker bio:
Kai Stroh earned a Computer Science degree from the University of Darmstadt and is a
mainframe software developer specializing in DB2 utilities for z/OS. He designs and builds
innovative DB2 applications and utilities often working onsite or remotely with UBS’ international
clients. He easily navigates his way around DB2 internals and knows how to move data and
definitions across DB2 versions, and this includes the unique in-house DB2 subsystems which
each have their own little technical adaptations.
Session title: The Good, Bad, & UGLY: Buffer Pool Tuning - - Bob Tilkes IBM
Session abstract:
This session will provide detailed information on buffer pool tuning, performance, Db2 object placement, and buffer pool configuration (i.e., recommended specifications for buffer pools for LOBs, work file table spaces, in-memory caching of entire objects, etc.). Drawing from his experience as an IBM Db2 for z/OS SWAT team member, Bob will provide examples from engagements with clients around the world, and on what he has seen in the field. The goal is to provide the tools to be able to have better application performance and efficiency using Db2 buffer pool tuning best practices.
Speaker bio:
Bob Tilkes is an IBM Senior IT Specialist, a member of the Db2 For z/OS SWAT team based out of the IBM Silicon Valley Lab with over 24 years working directly with Db2 z/OS. His experience includes the past 30+ years as an IBM customer working in the following roles: Lead Db2 z/OS system engineer, database administrator, and application developer. He has extensive experience in Db2 z/OS installation/migration, security (design, audit, compliance, & governance), Db2 z/OS application modernization, vendor tool management (installation & support) focusing on high performing, highly available, and highly resilient systems/applications. Prior to joining IBM, he was an active member of the Db2 for z/OS and Db2 for z/OS Tools Customer Advisory Council. In Bob’s current role as a Sr IT Specialist, IBM Software Support (Db2 for z/OS SWAT) he conducts consulting, educational workshops, Db2 health checks, and Db2 for z/OS 360 Continuous Availability Studies for worldwide customers. He assists in developing and instructing the content for the Db2 for z/OS Master class for North America and EMEA. He has also presented on numerous Db2 topics at IBM Conferences (US), IDUG NA, and local Db2 User Groups.