Meeting Agenda – June 7th, 2022
8:45 - 9:00 AM CST
Introduction by Chris Muncan/Dustin Ratliff, IDUG, Tom Glaser, Mastercard & Scott Follmer, Cigna… for the STLDUG, WDUG, MWDUG, Twin Cities, and Any Other UG’s
9:00 - 10:00 AM CST
SMF... An Epic Tale of Value, Volume, and Visualizations
Adrian Burke, Solutions Architect
Operational IT as it pertains to the Mainframe, and specifically SMF data, continues to expand in complexity and volume. This is diametrically opposed to the industry trend of downsizing teams, spending, and relative investment. With key metrics available to not only detect, but also predict bottlenecks, application outages, and capacity constraints customers cannot afford to ignore or throw away SMF data. Many times, the most voluminous data is the only data which can exonerate or implicate an application during root cause analysis. This presentation aims to identify key metrics being ignored or summarized by mainframe shops today and delve into creative ways to mine and analyze SMF data while avoiding increased costs.
10:00 - 11:00 AM CST
NULLs: The Good, the Bad, and the Really Ugly Bad
Doug Partch, IBM Data Information Champion
This presentation discusses designing and using NULLs in a database. We will deep dive into when and not NULLs should be applied to columns in table, indexes, and performance impacts of doing so. Next, we will cover predicate filtering, sorting, and joining tables. To finish off the NULLs topic we show the Ugly side of handling Nulls in applications, and when users write SQL and get unexpected results or extremely bad performance.
11:00 – Noon CST
How to Slow Down Db2 in One Summer
Sheryl Larsen, Senior Db2 Z Consultant
It may be one summer, collection, package or one query brings your CPU to its knees. These are the war stories that I will cover so you can learn from others’ mistakes. Examples of seriously delayed filtering, not following the 23 performance rules, checking to see if Db2 is up, and many other tricky but painful techniques will be divulged.
Objective 1: Tell the whole story of a Health Care Provider that has no Sheriff
Objective 2: Tell the story of Whale in the RID pool
Objective 3: Let’s walk through 23 SQL Performance Rules that humans need to take care of
Objective 4: Tell of recent Db2 war stories
Objective 5: Teach the skills to technology needed to keep Db2 running smoothly
Noon - 1:00pm CST
Control Your Applications Like Never Before with Db2 13
Jack Tucker, Software Architect
This session will cover the details on how the new application controls in Db2 13 allow more granular timeout values and deadlock management. You will also learn how you can increase the performance of your applications, by improving concurrency, while reducing the number of Db2 subsystems.
1:00pm - 2:00 pm CST
User Lead Roundtable
Theo Poole, WDUG President
Do you miss the conversation and collaboration of our live sessions? Since we're still virtual after all this time, we thought we'd give this roundtable session a try. An opportunity for folks to discuss relevant Db2 topics and share experiences across their organizations. Let's become a community once again, even if it is only virtually! And with our extended reach by partnering with other user groups, our pool is wide open. Enjoy some real-world discussions with people who have relevant experience!
Adrian Burke is an Open Group Master Certified IT Specialist currently serving as a Solutions Architect at Ocient. His mission is to help customers ingest and analyze the world’s largest datasets. In his previous role as a technical advocate for Db2 for z/OS he conducted consulting and educational workshops, DB2 health checks, and availability studies for the largest Db2 for z/OS installations. Adrian has spoken at numerous Db2 Regional User Groups both in the U.S. and abroad as well as presented at IDUG and SHARE. He is also a published Redbook author on material dealing with Db2 performance.
Doug Partch has over 30+ years of Information Technology experience in the fields of Enterprise Data Architecture, Data Governance, and Relational database technology. Recognized as an IBM Data Information Champion for 10+ years, specializing in Relational database technology focusing on the Db2 family of products, mainly DB2 LUW and z/OS. He has spoken at many local, regional, and national conferences; as well as has published several articles and assisted other IBM Champion Authors writing best practices, performance, and database design topics in books.
Sheryl Larsen is the Senior Db2 Z Consultant at Accenture Federal Services. Previously she worked for TxMQ, BMC, IBM, Sheryl M. Larsen, Inc., and Platinum Technology (now Broadcom). She is known for her extensive expertise in SQL Tuning and has performed detailed Db2 Performance Health Checks for 42 Fortune 500 clients. Sheryl has over 30 years’ experience in Db2, has published many articles, white papers and co-authored a book, Db2 Answers, Osborne-McGraw-Hill, 1999. Currently she is the President of the Midwest Db2 User Group, an IBM Z Champion, and a member of the Northern Illinois University Computer Science Alumni Council.
Jack Tucker is a Software Architect for the Broadcom Performance Suite for Db2 for z/OS. Jack has over 35 years of experience working with Db2 and has delivered solutions across the Administration, Backup and Recovery, Utilities, and Performance areas at Broadcom, CA Technologies and PLATINUM Technology. Prior to Jack moving to the architecture role at CA Technologies, he was the Senior Director of Software Engineering for the Db2 Backup/Recovery and Db2 Utilities teams. Jack's areas of expertise are Db2 Backup and Recovery and Db2 Utility processing.
Meeting Agenda – Jun 8, 2022
Zeljen Stanic, IDUG
Shelley Mizerak/WDUG… for the STLDUG, WDUG, MWDUG, Twin Cities
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!
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.