Meeting Agenda – Dec 01, 2020
8:50 - 9:00 AM CST
Introduction by Zeljen Stanic/IDUG… for the STLDUG, WDUG, MWDUG, Twin Cities
9:00 - 10:00 AM CST
Top 25+ SQL Tuning Tips for Developers
Tony Andrews, Themis
Most relational tuning experts agree that the majority of performance problems with applications that access a relational database are caused by poorly designed programs or improperly coded SQL. Every programming language has efficiencies and inefficiencies and SQL is no exception. Does your IT shop or team have SQL standards and/or Best Practices? This presentation is one that every Db2 developer should see and follow to empower them to become better developers and minimize performance issues.
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
Containers, Cloud Paks, OpenShift – What Mainframers Should Know
Elton de Souza, IBM
In this presentation IBM Chief Architect and Wizard Elton de Souza will cover the value proposition of OpenShift on IBM Z from a technical and business standpoint. Elton will also cover integration points between OpenShift and zOS services and data sources.
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.
11:00 – Noon AM CST
Help! I’m overwhelmed with all these metrics in my Db2 monitor
Robert Andresen, Broadcom
You want to improve Db2 performance, but what do I look for? There are many different monitors and tools hundreds of screens and over 1500 of metrics. It can be overwhelming, especially if you are not familiar with the application or new to Db2 or the mainframe.
Bio: Robert Andresen is a Principal Consultant with Broadcom. He has been working in performance management and monitoring for several software companies since 1997 and has been supporting mainframe systems since 1976 in various capacities including being a zOS/CICS/DB2 Systems Programmer. He is a co-author of the IBM Redbook: Linux on IBM @server zSeries and S/390: System Management. He has presented at IDUG, CMG, SHARE, the IBM zOS Conference and LinuxWorld as well as many local and regional user groups. He holds a degree in Mathematics from the Illinois Institute of Technology. He is certified as an IBM Certified Database Administrator, DB2 10 and 11 for z/OS, an IBM Certified SOA Associate and also is ITIL Foundation Certified. At CA he has been supporting their suite of Db2 for z/OS. His areas of expertise include z/OS, DB2, CICS, UNIX/Linux, Windows, and R.
Noon – 1:00 PM CST
Sogei’s Experience with IBM Db2 Analytics Accelerator
Chiara Baldan, Sogei (Rome, Italy)
This session includes an overview of Sogei's main applications running on IBM Db2 Analytics Accelerator, the challenges faced, and the benefits achieved.
Moreover, Sogei took part in the Db2 Analytics Accelerator V7 InSync Early Support Program, find out about this new technology and the outcome of this experience.
Bio: Chiara Baldan has 18 years' experience with mainframe platform, working for support services, as systems programmer and database administration. She joined Sogei 7 years ago and, since 2018 she is working for the 'Service & Technology Innovation Hub'. She is part of a team working to optimize data, their delivery, storage, and processing. The main goals are to improve data strategy and data integration using AI, ML and data analytics technologies. Chiara contributes to modernize mainframe platform to face up to the challenges of today.