Meeting Agenda – June 7th, 2022
8:45 - 9:00 AM CST
IDUG News
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!
_____________________________________________________________________
Speaker Bios:
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.