IDUG NA 2026: Full Schedule

arrow_back View All Dates

10:20am EDT

A10 | Revisiting Parallelism: Targeted Use of zIIP Processors for Db2 Queries

Wednesday October 28, 2026 10:20am - 11:20am EDT

This presentation explores the nuances of query parallelism in Db2, focusing on how to effectively tune queries for optimal zIIP exploitation. Attendees will gain insights through real-world query examples, highlighting the critical distinction of query access paths between iterative and merge strategies that are key to achieving successful query parallelism. Practical use cases will illustrate these principles in action, showcasing tangible improvements. Additionally, we will discuss how ChatGPT can assist in the query tuning processs. Join us to rediscover the power of parallelism and leverage zIIP processors to their fullest potential.

Speakers

Thomas Baumann

Data Evangelist, Swiss Mobiliar

As Data Evangelist at Swiss Mobiliar in Bern, Switzerland, Thomas is dedicated to optimizing databases and managing database risks. When he's not in the office, he can be found sharing his expertise on database optimization and risk management at various speaking engagements. Thomas... Read More →

Wednesday October 28, 2026 10:20am - 11:20am EDT
Magnificent 3

Track A, Technical Session

Audience All
Subject z/OS
Area Best Practices, Performance and Monitoring, User Stories, Working with SQL

10:20am EDT

B10 | Hard Lessons Learned with High Performance DBATs for Db2 for z/OS

Wednesday October 28, 2026 10:20am - 11:20am EDT

Magnificent 1

High Performance DBATs (HP DBATS) is a very important performance feature of Db2 for DDF workloads. If applied and used intelligently this feature can generate significant savings in CPU resource consumption. This session will cover the following topics: what is a connection?; what is a DBAT (THREAD)?; thread (DBAT) pooling and DRDA inactive connections; what are High Performance DBATs; good candidate application workloads for High Performance DBATs; general guidance for configuring High Performance DBATs; performance metrics and monitoring; WLM and High Performance DBATs; Issues; Summary.

Speakers

John Campbell

Distinguished Technical Consultant, Broadcom

John is an IBM Alumni, a retired IBM Distinguished Engineer, and now works as a Distinguished Technical Consultant for Broadcom Inc. He has worked with Db2 for z/OS for over 40 years and has extensive experience with Db2 in terms of systems, database and application design. He specialises... Read More →

Wednesday October 28, 2026 10:20am - 11:20am EDT
Magnificent 1

Track B, Technical Session

Audience All
Subject z/OS
Area Best Practices, Performance and Monitoring, User Stories

10:20am EDT

C10 | Stabilize your Dynamic SQL and don’t let it remain Unpredictable

Wednesday October 28, 2026 10:20am - 11:20am EDT

Magnificent 4

In the world of Db2 for z/OS, SQL performance tuning is one of the most critical and often most complex of DBA tasks. While static SQL has long been the standing order for traditional mainframe applications, the growing use of dynamic SQL - driven by modern applications, APIs, and distributed workloads - has changed the tuning game.Dynamic SQL’s agility and flexibility introduces a new layer of complexity that can hinder performance if not well managed and cause inconsistent performance and even be unpredictable. Dynamic SQL is becoming more prevalent as agile development and hybrid workloads become the norm. But with the flexibility of dynamic SQL comes responsibility - DBAs must adapt and develop new ways of monitoring and tuning dynamic workloads in real-time and across the application lifecycle. Colin Oakhill will share a proven approach to bring order to chaos by giving DBAs the visibility, control, and insight they need to ensure that dynamic SQL performs efficiently and predictably. Just like long-time DBAs are used to with static SQL.

Speakers

Colin Oakhill

Senior Technical Advisor, Insoft Infotel Software GmbH

Colin has been working with mainframes since 1974. Along his career he has worked as a systems programmer, DBA and developer. He started with CICS & IMS systems and with Db2 since 1988. He founded InSoft in 1986 and was chief architect and developer for the Db2 products. As part of... Read More →

Wednesday October 28, 2026 10:20am - 11:20am EDT
Magnificent 4

Track C, Technical Session

Audience Intermediate
Subject z/OS
Area Best Practices, Latest and Features z/OS, Performance and Monitoring

10:20am EDT

IDUG Db2 for z/OS Essentials

Wednesday October 28, 2026 10:20am - 5:30pm EDT

Magnificent 2A

Speakers

Luis Antonio Alguera

Db2 for z/OS Essentials Instructor, LearnQuest

Luis Alguera, MSBA, is an IBM instructor, technology consultant, and data science professional with more than 15 years of experience delivering IBM training and consulting services. He has extensive experience with Db2 database administration across distributed and mainframe environments... Read More →

Sponsors

LearnQuest

Wednesday October 28, 2026 10:20am - 5:30pm EDT
Magnificent 2A

Essentials, Essentials

Audience Beginner
Subject z/OS

11:30am EDT

A11 | RTS-/Utility History and preparations for Vnext

Wednesday October 28, 2026 11:30am - 12:30pm EDT

Magnificent 3

This presentation will cover how to benefit from using Real Time Statistic (RTS) and Utility History. I will explain a useful established example of Real Time Statistic History, share which usecases are covered by RTS History and why RTS Temporal out of the box is not sufficient for everyone.
Second part will share some necessary preparations for Vnext and will cover one path and best practices to get rid of deprecated non-UTS tablespaces, what to consider and why utility history is really helpful. It will give some early experiences on FL509 support to migrate remaining Catalog&Directory tablespaces. Relevant topics like “workfile separation” will be covered as well.

Speakers

Ute Kleyensteuber

Principal Product Owner, Commerzbank AG

Ute Kleyensteuber is a Principal Product Owner, Senior Infrastructure Engineer and Director at Commerzbank AG in Germany, responsible for Db2 for z/OS since more than 35 years. Knowing and working with Db2 since Version 1.2 I've extensive experiences of Db2 in terms of system- and... Read More →

Wednesday October 28, 2026 11:30am - 12:30pm EDT
Magnificent 3

Track A, Technical Session

Audience All
Subject z/OS
Area Best Practices, Latest and Features z/OS, User Stories

11:30am EDT

B11 | Let Me Make This as Clear as Robert: Explaining Often-Misunderstood Db2 for z/OS Buffer Pool & Group Buffer Pool Concepts

Wednesday October 28, 2026 11:30am - 12:30pm EDT

Magnificent 4

Some aspects of Db2 for z/OS BP & GBP technology are plain as day; others, less so. Questions we get from Db2 users worldwide have highlighted for us things that a lot of folks - even very experienced Db2 people - get wrong. In this session we'll try to bring clarity to oft-misunderstood areas of Db2 for z/OS BP & GBP technology.

Speakers

Anna McKee

Technical Enablement Specialist, IBM

Anna McKee is a Technical Enablement Specialist in the IBM Z Ecosystem Infrastructure, where she manages and supports all Db2 for z/OS subsystems. She works with hundreds of independent software vendors to deliver the latest SMPE maintenance, perform Db2 installations and configurations... Read More →

Mark Rader

Db2 for z/OS Specialist, IBM

Mark Rader is a Db2 for z/OS specialist in the IBM Z Worldwide Systems Center (WSC, and formerly Washington Systems Center). Mark has applied his Db2 for z/OS experience with clients across a wide variety of projects, with emphasis on availability, performance and Db2 for z/OS data... Read More →

Wednesday October 28, 2026 11:30am - 12:30pm EDT
Magnificent 4

Track B, Technical Session

Audience All
Subject z/OS
Area Best Practices, Latest and Features z/OS

11:30am EDT

D11 | BMC Db2 High Speed Utilities - What's new !!

Wednesday October 28, 2026 11:30am - 12:30pm EDT

Magnificent 5

A review a of recent enhancements to the BMC Db2 High Speed Utilities

Speakers

Michael Cotignola

Db2 Solutions Engineer, BMC Software

Already on file

Wednesday October 28, 2026 11:30am - 12:30pm EDT
Magnificent 5

Track D, Technical Session

Audience All
Subject z/OS
Area Utilities

11:30am EDT

E11 | Navigating Digital Certificates: Unlocking a Seamless Experience

Wednesday October 28, 2026 11:30am - 12:30pm EDT

Magnificent 6

Generating digital certificates while installing a product like DB2 and related products on z/OS frequently involves intricate hurdles, where minor errors lead to postponed rollouts, service interruptions, and heavy manual workloads. This session breaks down the core principles of certificates while offering actionable techniques and proven methods to refine your workflow. Furthermore, we will debut an innovative utility engineered to simplify the baseline certificate configuration during mainframe software deployment, minimizing technical friction and fast-tracking your path to production.

Speakers

Jan Prihoda

Product Owner, Broadcom Mainframe Software

Jan is an experienced Product Owner at Broadcom responsible for making the Broadcom products configuration process smoother. He has long experience in software development in the telecommunication industry and now he is trying to combine his experience and mainframe complexity to... Read More →

Denis Tronin

Product Manager, Broadcom

Denis Tronin is a seasoned Product Manager in Broadcom’s Mainframe Software Division, bringing years of experience in product management and software development. His work focuses on mainframe technologies, specifically in Data Management and DevOps domains. He plays a key role... Read More →

Wednesday October 28, 2026 11:30am - 12:30pm EDT
Magnificent 6

Track E, Technical Session

Audience Beginner
Subject z/OS
Area Best Practices, Security and Compliance

11:30am EDT

F11 | A day in the life of an MFA-enabled Db2 for z/OS DBA

Wednesday October 28, 2026 11:30am - 12:30pm EDT

Magnificent 7

As enterprise security threats evolve, Multi-Factor Authentication (MFA) has become essential for safeguarding access to mission-critical systems like Db2 for z/OS. This session provides an inside look at a day in the life of a Db2 for z/OS administrator navigating an MFA-enabled environment. From securely logging in and managing authentication challenges to executing routine database tasks with enhanced security controls, we’ll examine how MFA impacts daily workflows, troubleshooting, and compliance requirements. Attendees will gain practical insights into best practices, potential challenges, and strategies for balancing security with productivity. Additionally, we’ll explore a range of access methods, from traditional TSO to modern tools like Db2 for z/OS Administration Foundation, SQL Tuning Services, and the Db2 for z/OS Developer Extension for VS Code.

Speakers

Jørn Thyssen

Senior Technical Staff Member, Rocket Software

Jørn Thyssen is a Senior Technical Staff Member at Rocket Software, working with mainframe and Db2 tools in customer modernization and performance projects. He has extensive experience with IBM Z and Db2 for z/OS, and collaborates closely with development teams on initiatives involving... Read More →

Wednesday October 28, 2026 11:30am - 12:30pm EDT
Magnificent 7

Track F, Technical Session

Audience Intermediate
Subject z/OS
Area Security and Compliance

2:00pm EDT

C12 | Efficiently Finding and Fixing High Resource Consuming SQL

Wednesday October 28, 2026 2:00pm - 3:00pm EDT

Magnificent 4

This presentation will demonstrate how to find, analyze and tune the top 40 expensive queries. Special emphasis will be on finding the cursors that could benefit from multi-row fetch. In addition, discussions on designing perfect indexes, MQTs and AQTs, along with manual query rewrite, SQL exploitation and most important, proper use.

Speakers

Sheryl Larsen

President, Sheryl M Larsen LLC

Sheryl Larsen is an internationally recognized researcher, consultant and lecturer, specializing in DB2 and is known for her extensive expertise in SQL. Sheryl has over 30 years’ experience in DB2, has published many articles, several popular DB2 posters, and co-authored a book... Read More →

Wednesday October 28, 2026 2:00pm - 3:00pm EDT
Magnificent 4

Track C, Technical Session

Audience All
Subject z/OS
Area AppDev, Back to Basics, Best Practices, Latest and Features z/OS, Modernization in Development, User Stories, Working with SQL

2:00pm EDT

D12 | Db2 13 GA to 507 - My 5 favourite things

Wednesday October 28, 2026 2:00pm - 3:00pm EDT

Magnificent 5

Db2 13 for z/OS became available in 2022, and via the continuous delivery model, IBM has continued to deliver a wealth of new capabilities and enhancements. The latest features offer numerous benefits, including resource savings, enhanced security, and simplified administration. In this session we will walk through my personal “top 5”, favourite features delivered in Db2 13. Join me to hear about these new features, including utility enhancements, monitoring connections and more, and learn how you can exploit them to get the most out of this version of Db2 for z/OS.

Speakers

Tom Crocker

Principal Solution Advisor, Rocket Software

Tom Crocker is a Principal Solution advisor working with IBM Db2 Tools for z/OS, and has been working with Db2 since v1.2. He specialises in Db2 administration and mainframe modernisation, working with customers across the globe to provide solutions and to enable them to get the best... Read More →

Wednesday October 28, 2026 2:00pm - 3:00pm EDT
Magnificent 5

Track D, Technical Session

Audience Intermediate
Subject z/OS
Area Latest and Features z/OS

2:00pm EDT

E12 | Autonomous Auditing of Native Db2 Security Features

Wednesday October 28, 2026 2:00pm - 3:00pm EDT

Magnificent 6

Are you challenged with tasks having to provide audit reports detailing who has access to which objects and who has which privileges – even worse, who had access 3 months ago ?Many Db2 sites are using a log tool to accomplish these tasks – but are you aware of the relatively new capabilities in Db2 dealing with security information stored in the catalog ?We will dive into what Db2 has to offer natively and how you can handle regulatory requirements in an easier way augmenting your current processes.

Speakers

Steen Rasmussen

Customer Services Consultant, Broadcom

Steen Rasmussen is a Customer Services Consultant currently instrumental in the ongoing development and support of the Broadcom Db2 solutions. In 1985 Steen started as an IMS/DB2 DBA at a major insurance company in Denmark working with all aspects of DB2 - like tuning, application... Read More →

Wednesday October 28, 2026 2:00pm - 3:00pm EDT
Magnificent 6

Track E, Technical Session