Meeting Agenda – Jun 8, 2022
8:45 - 9:00 AM CST
Zeljen Stanic, IDUG
Shelley Mizerak/WDUG… for the STLDUG, WDUG, MWDUG, Twin Cities
9:00 - 10:00 AM CST
Query Optimization Explained (in one hour)
John Hornibrook - IBM
Optimal query access plans are essential for good data server performance and it is the Db2 query optimizer's job to choose the best access plan. The optimizer is a very sophisticated component of the data server; tasked with the challenging job of choosing good access plans for the variety of features and table organizations supported by Db2. The optimizer can automatically rewrite complex SQL resulting in huge performance improvements. It models various aspects of Db2 runtime so that it can choose the best access plan out of hundreds of thousands of possible options. Attend this session to get an overview of how the optimizer works and to get some tips on how to understand its decisions and control its behaviour. All in under an hour!
10:00 - 11:00 AM CST
Improving ETL Performance
Calisto Zuzarte - IBM Canada Lab
This session focuses on (a) tips to improve ETL performance (b) ETL considerations to benefit your post-ETL warehouse query workload. Whether you load new data into your Db2 warehouse weekly, nightly, or more frequently, invariably there are time constraints that need to be paid attention to. Besides meeting the ETL SLA itself, optimizing ETL strategy so that the subsequent query workload performs well is another important consideration. This session provides tips for optimizing ETL as well as tips for ETL considerations to help improve subsequent query workloads.
11:00 - 12:00 PM CST
Adaptive Workload Management: What's New and Best Practices
Db2’s new Adaptive Workload Management technology vastly simplifies the task of dividing your database resources across workloads to ensure they meet their performance objectives. Unlike traditional workload managers, it manages the admission of jobs based on their actual resource needs and intelligently schedules them based on the resource targets you assign. This ensures stable and reliable performance, even in the face of the most highly concurrent workloads. Join David Kalmuk, the architect of the Adaptive Workload Manager, for an update on new enhancements in the latest release and best practices that will allow you to get the most out of this technology.
John Hornibrook is a Senior Technical Staff Member responsible for relational database query optimization on IBM's distributed platforms. This technology is part of Db2 for Linux, UNIX and Windows, Db2 Warehouse, Db2 on Cloud, IBM Integrated Analytics System (IIAS), IBM Db2 Analytics Accelerator (IDAA) and Db2 Big SQL. John also works closely with customers to help them fully realize the benefits of IBM's relational DB technology products.
Calisto Zuzarte is a Senior Technical Staff Member (STSM) in the Db2 development organization. His focus as an architect is database query optimization and performance. He holds 50+ patents and 50+ research publications in this area.
David Kalmuk, IBM, is a Senior Technical Staff Member & Master Inventor with responsibility for the MPP scale-out, Workload Management, and Monitoring areas of the Db2 family products. David has contributed to the development of numerous technologies in Db2 over the years including BLU Acceleration, Workload Management, Monitoring, as well as much of Db2’s Processing and Communications architecture. He is currently leading efforts focused on evolving Db2's Hybrid Warehousing Architecture.