Wisconsin Db2 Users Group
Log in

Upcoming events

    • 03/02/2021
    • 8:45 AM - 12:00 PM (CST)
    • https://global.gotomeeting.com/join/166667277
    Register

    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:

    • Take a pictorial view at how Db2 for z/OS processes SQL from the inside out.
    • Learn what Db2zAI can and cannot do
    • Learn to put a query on diet
    • Learn how you can change the optimizers mind
    • Increase your confidence in recognizing sub-optimal SQL

    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.

    • 03/03/2021
    • 8:45 AM - 11:00 AM (CST)
    • https://global.gotomeeting.com/join/837823253
    Register

    Meeting Agenda – Mar 3, 2021

    8:45 - 9:00 AM CST

    Introduction by Shelley Mizerak/WDUG… for the STLDUG, WDUG, MWDUG, Twin Cities

    9:00 - 10:00 AM CST

    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

     

    10:00 - 11:00 AM CST

    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.


Powered by Wild Apricot Membership Software