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.
Meeting Agenda – Dec 02, 2020
8:45 - 9:00 AM CST
Advance Query Tuning with IBM Data Studio
In my opinion, one of the best query tuning tools on the market. And if I’m running a project, every developer should have this tool on their desktop. If you are often curious ‘why’ the optimizer chooses a certain index, join order or access path then this tool will get you those answers. And by doing so helps to get the right solution for query improvement. This presentation is designed for the Db2 professional who desires to understand the fundamental issues with performance for Db2 applications. Emphasis is placed on understanding optimization, many access paths chosen by the optimizer, filter factors, along with how to read and understand visual explain access paths. Performance related issues in the areas of database design, indexing, application SQL coding, and data statistics will be addressed. Presentation has examples in both Db2 z/OS and LUW.
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’.
Db2 Basics: Monitoring and Troubleshooting Db2
This is an introductory session, aimed at those who have been working with Db2 on Linux, UNIX, or Windows for two years or less. We'll go through the basics of how to investigate problems of all kinds with Db2, including some tips and tricks learned with over 19 years of experience supporting Db2.
Bio: Ember Crookshas 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.
What's New with BLU in Db2 11.5
Chris Drexelius, IBM
Db2 with BLU Acceleration provides industry leading performance for analytical applications running complex queries through its advanced column-organized table technology. Db2 11.5 continues to extend the reach of BLU capability to more Db2 features so that its superior performance can be applied to a broader range of applications. Additionally, BLU storage and compression technology has been enhanced to make it more effective and even easier to use. Attend this session to learn how these enhancements can allow BLU to be used for even more applications within your business.
Bio: Chris Drexelius is a Senior Software Engineer at the IBM Silicon Valley Laboratory and product owner for storage and compression for Db2 with BLU Acceleration with deep knowledge in the areas of storage, compression, memory management, indexing, and I/O processing. Db2 with BLU Acceleration is the common database engine technology used in Db2 for Linux, UNIX and Windows, Db2 Warehouse, Db2 on Cloud, IBM Integrated Analytics System (IIAS) and Db2 Big SQL. Chris has developed features for dictionary evolution, automatic dictionary creation (ADC), prefetching, and Db2’s XML datatype support.