Meeting Agenda – Mar 2, 2021
8:50 - 9:00 AM CST
Introduction by Tom Glaser, Mastercard… for the STLDUG, WDUG, MWDUG, Twin Cities
9:00 - 10:00 AM CST
The Power of the SQL Rewrite - <Dual presentation for both z/OS and LUW attendees>
Tony Andrews
Often times there are 4,5,6 different ways to get the same result set back. Sometimes there are 3,4,5 different ways to write an SQL predicate differently and still maintain the same logic. Why is this important, and what makes any of them betters than the others? Developers need to be strong in SQL especially for performance and tuning reasons because rewriting SQL differently often times cause the optimizer to gather the results set differently. This presentation breaks down many examples of SQL rewrites and how they affect performance and optimization.
BIO:Tony Andrews has more than 25 years’ experience in the development of relational database applications. Most of this time, he has provided development and consulting services to Fortune 500 companies and government agencies. Tony has written literally thousands of queries and programs during his development years and has also served as a database analyst. For the last 10+ years, Tony has been splitting his time between performance and tuning consulting engagements along with training. His main focus is to teach today’s developers the ways of RDBMS application design, development and SQL programming -- always with a special emphasis on improving performance. He is a current IBM Champion, and regular speaker at many regional user groups, IDUG NA, and IDUG EMEA. He is also the author of a book for developers titled ‘DB2 SQL Tuning Tips for z/OS Developers’.
10:00 - 11:00 AM CST
Tuning SQL that still works
Sheryl Larsen
Gone are the days of manually tuning queries. NOT SO FAST! As smart as the internal Virtual Data Scientist, inside Db2zAI is, there are many techniques that it cannot apply. Query re-write lives on in an Agile work environment! Human eyes are still required on projects demanding only high-performance SQL moves on into production. Sheryl will cover all kinds of techniques that are still best practice rules to follow. Perfect for newbies to Db2 for z/OS due to all the pictures used to demonstrate techniques, as well as oldies, who need a refresher.
Objectives:
Bio: Sheryl M. Larsen is the Worldwide Db2 Z Solutions Ambassador at BMC. Previously she worked for 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 many 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.
11:00 – Noon AM CST
Openshift for Z
Elton de Souza
In this session we will talk about the changes in Cloud Paks in 2021 and their relevance for the IBM Z and LinuxONE platform. We will also talk about updates in z/OS integration (z/OS Cloud Broker, Ansible for z/OS, WAZI etc) with Cloud Paks and cover client success stories from 2020 in the cloud native modernization space on IBM Z.
Bio: Elton de Souza is the Chief Architect for Cloud Native Client Success focusing on IBM Z and LinuxONE. Since OpenShift GA’d on IBM Z in Feb 2020, Elton has helped several clients across various sectors and geographies implement RHOCP on IBM Z and LinuxONE. He’s spent almost his entire career on IBM Z starting from the Java compiler for Linux and zOS to working on Open Source Solutions (MongoDB, node.js, Spark, Docker, Kubernetes, etc.) to IBM Cloud Private and now Red Hat OpenShift on IBM Z.
Meeting Agenda – Mar 3, 2021
8:45 - 9:00 AM CST
Introduction by Shelley Mizerak/WDUG… for the STLDUG, WDUG, MWDUG, Twin Cities
Db2 Problem Determination and Debugging
Pavel Sustr
As a member of the Db2 LUW development and support team, Pavel uses Db2 problem determination techniques on a daily basis. Whether it is problems reported by test teams, related to his newly written code (rarely happens ;-), or tough customer reports from the field, there are techniques that can lead to a problem resolution more quickly.This session presents some less known or in some cases undocumented tricks and hidden gems that might help the user troubleshoot Db2 issues and even build their reputation as a serious Db2 hacker/insider.
Objectives: Present less known problem determination techniques Understand the diagnostic data returned by the techniques Discuss the best use cases for the individual techniques Master shortcuts leading to problem resolution Get an insider view of problem determination techniques used by the IBM Db2 team
Speaker Bio: Pavel Sustr is always thrilled to work on hard-to-crack puzzles. Expertise in Db2 LUW kernel architecture, configuration and administration, advanced problem determination, memory architecture, memory leak troubleshooting, and assembly language. Hands-on development experience with buffer pool management, storage, prefetching, page cleaning, transaction logging, recovery, monitoring, and problem determination. As a member of the Db2 team, Pavel spent years in Db2 L2/L3 advanced support (over 1,500 resolved cases), then transitioned to Db2 LUW kernel development. In his past life Pavel was an application developer mostly using C++, SQL, .NET, Oracle, MS-SQL, and Informix on Windows, Linux, Solaris, and HP-UX
Should you embrace DevOps? An experienced Db2 DBA's Journey into DevOps
Ember Crooks
DevOps is a revolution in how technology is approached that gains in adoption every year. Join Ember Crooks as she shares her journey into a fairly mature DevOps shop as a DBA with no previous DevOps experience. In this session, we will:
· Discuss what DevOps is and what it isn’t
· Explore what DevOps means to the DBA
· Understand at a high-level some of the decision points around running databases in containers
Review a few DevOps tools a DBA should be familiar with
Bio: Ember Crooks has 19+ years of experience with Db2 on Linux, Unix, and Windows platforms. She is the founder and principal author of the popular datageek.blog technical blog where she educates herself and others through example and case study. Ember is an IBM Gold Consultant and IBM Champion in Information Management.