Meeting Agenda – Dec 02, 2020
8:45 - 9:00 AM CST
Introduction by Zeljen Stanic/IDUG… for the STLDUG, WDUG, MWDUG, Twin Cities
9:00 - 10:00 AM CST
Advance Query Tuning with IBM Data Studio
Tony Andrews, Themis
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’.
10:00 - 11:00 AM CST
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.
11:00 – Noon AM CST
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.