Wisconsin Db2 Users Group
Log in

June 2022 WDUG VIRTUAL Db2 for z/OS Meeting

  • 06/07/2022
  • 8:45 AM - 2:00 PM
  • https://meet.goto.com/464919517


  • Registration for all WDUG Members and contacts for the z/OS virtual session.

Registration is closed

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!


    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.

    Powered by Wild Apricot Membership Software