IDUG NA 2026: Full Schedule

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

F10 | AI as a partner for the Db2 Professional

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

Magnificent 7

Db2 professionals manage complex and mission-critical data environments where troubleshooting, performance analysis, and knowledge discovery can be time-consuming. In this session, we explore how GenAI can assist Db2 professionals by helping understand database structures, maintain environments and accelerate problem diagnosis. Through practical examples, we demonstrate how AI can act as a partner, augmenting expertise and helping teams work more efficiently while maintaining the reliability expected from enterprise Db2 systems.

Speakers

Claire Connor

Principal Presales Consultant, Geniez AI

Claire Connor is a Principal Presales Consultant at Geniez AI, specialising in agentic AI and mainframe modernisation. With deep experience across IBM, managed service providers, and hybrid‑cloud strategy, she helps enterprises bridge legacy systems with cutting‑edge AI. Claire... Read More →

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

Track F, Technical Session

Audience All
Subject AI / ML
Area AI GenAI and Machine Learning, Best Practices, Modernization in Operations

11:30am EDT

G11 | IDUG Db2 LUW Expert Panel

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

Magnificent 1

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

Expert Panel, Expert Panel

Audience All
Subject LUW

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

12:30pm EDT

Lunch & Passport to Prizes Drawing

Wednesday October 28, 2026 12:30pm - 2:00pm EDT

Triumph C/D

Wednesday October 28, 2026 12:30pm - 2:00pm EDT
Triumph C/D

IDUG, Lunch

Audience All

2:00pm EDT

A12 | From complexity to operational intelligence : modernizing database administration with AI on IBMZ

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

Magnificent 3

SQL Data Insights (SQL DI) in Db2 13 for z/OS brings built‑in AI directly into the database, enabling organizations to discover patterns, detect anomalies, and generate insights using familiar SQL—without moving data or building complex pipelines.
This session provides practical guidance on getting started with SQL DI, beginning with Db2 instrumentation data as a high‑value entry point. It will also demonstrate how to extend insights by ingesting VSAM data through Data Virtualization Manager.
In addition, the session highlights recent SQL DI enhancements, including a unified embedding model, SQL-based AI access, and incremental training capabilities—enabling teams to seamlessly embed AI into existing Db2 workflows.
The session concludes with an overview of Industry Starter Kits, featuring prebuilt datasets, vector tables, and AI queries that accelerate adoption and help organizations quickly realize high‑value use cases.

Speakers

Akiko Hoshikawa

Db2 for z/OS development, IBM

Akiko Hoshikawa is a Distinguished Engineer at IBM’s Silicon Valley Laboratory, specializing in performance, AI-driven optimization and advanced data technologies. She leads initiatives that integrate artificial intelligence with Db2 for z/OS. Akiko’s work focuses on simplifying... Read More →

Jae Lee

Db2 for z/OS Development, IBM

Jae Lee is a Senior Software Engineer at the IBM Silicon Valley Lab, specializing in the development of Db2 AI for z/OS, SQL Data Insights, and the Db2 RDS component.

Catherine Wu

Program Director, IBM Db2 for z/OS Development and Product Management, IBM

Catherine (Yan) Wu is the Program Director for Db2 for z/OS at IBM’s Silicon Valley Lab, leading Db2 for z/OS development and product management. A skilled engineering leader, her expertise spans database management, data governance, machine learning, and enterprise design thinking... Read More →

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

Track A, Technical Session

Audience All
Subject AI / ML
Area AI GenAI and Machine Learning, Data Movement and Analytics, Working with SQL

2:00pm EDT

B12 | Supercharge Your Db2 Databases: Moving to Amazon RDS and Integrating AWS AI/ML

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

Magnificent 1

Whether you’re evaluating data movement paths for your Db2 databases or are interested in efficiently operating your already migrated Db2 databases on Amazon RDS, we’ve got you covered. In this session, learn about data movement paths, including those with minimal downtime, for Db2 databases. Explore real-world examples to learn best practices that help ensure high availability, optimize performance, and meet your compliance needs. Bring your questions and challenges—this interactive talk offers you the opportunity to hear directly from AWS experts and collaborate with your peers. Plus, see how to supercharge your applications by integrating AWS AI/ML services like Amazon Bedrock, Amazon Sagemaker directly with RDS for Db2. Join us to turn your database into a launchpad for innovation.

Speakers

Andrew Hilden

Chief Architect Db2 SaaS, IBM

Ashish Prasad

Solutions Architect, AWS

Ashish Prasad is a Solutions Architect with a focus on relational database (Db2, Oracle, PostgreSQL) and analytics at AWS. He works with AWS customers and certified partners to provide technical assistance and design customer solutions on cloud migration projects, helping customers... Read More →

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

Track B, Technical Session

Audience All
Subject LUW
Area AI GenAI and Machine Learning, Automation, Best Practices, Data Movement and Analytics, Data Movement and Integration, Database Resiliency

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

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

Audience All
Subject z/OS
Area Automation, Latest and Features z/OS, Security and Compliance

2:00pm EDT

F12 | Cost Optimization Strategies for Db2 in Public Cloud

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

Magnificent 7

As organizations continue modernizing enterprise database environments and moving workloads to public cloud platforms such as AWS, Azure, and Google Cloud, controlling operational cost has become one of the most critical success factors for cloud-based Db2 deployments.
This session provides a practical deep dive into cost optimization strategies for IBM Db2 environments running in public cloud infrastructures. Using real-world customer experiences and operational lessons learned, we will explore how to optimize compute, storage, networking, licensing, high availability architectures, backup strategies, and operational automation while maintaining enterprise-grade performance, resiliency, and security.
The session will cover common hidden cost drivers in cloud Db2 environments, including overprovisioned infrastructure, inefficient storage configurations, excessive replication traffic, backup retention overhead, idle standby resources, monitoring inefficiencies, and cloud-native operational challenges.
Attendees will learn actionable techniques for reducing cloud spend while improving operational efficiency through automation, observability, workload optimization, right-sizing strategies, and intelligent HA/DR design decisions.
This presentation is ideal for Db2 DBAs, cloud architects, infrastructure teams, SRE engineers, and technical leaders responsible for designing, operating, or optimizing Db2 environments in public cloud platforms.

Speakers

Mohan Saraswatipura

Senior Consultant, DBA Automation

Mohankumar Saraswatipura is an IBM Gold Consultant specializing in database solutions. His background demonstrates versatile expertise in database architecture and administration, particularly with Db2 environments.

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

Track F, Technical Session

Audience All
Subject LUW
Area Db2 Cloud and Warehouse

2:00pm EDT

IDUG Badging

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

Magnificent 2B

Sponsors

IDUG

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

Badging, Certification & Badging

Audience All
Subject LUW

3:00pm EDT

Coffee Break

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

Triumph C/D

Wednesday October 28, 2026 3:00pm - 3:20pm EDT
Triumph C/D

IDUG, Break

Audience All

4:30pm EDT

G13 | IDUG Db2 z/OS Expert Panel

Wednesday October 28, 2026 4:30pm - 5:30pm EDT

Magnificent 3

Wednesday October 28, 2026 4:30pm - 5:30pm EDT
Magnificent 3

Expert Panel, Expert Panel

Audience All
Subject z/OS

4:30pm EDT

A13 | Your AI Toolbox in Db2: Picking the Right Model When Everyone's Telling You to Use an LLM

Wednesday October 28, 2026 4:30pm - 5:30pm EDT

Magnificent 4

The AI problems landing on the desks of DBAs and application developers this year don't all need the same model. Some call for a Large Language Model. Others need a forecasting model, a clustering algorithm, or an embedding model. Plenty can be solved by predictive techniques that have been working quietly for years. One drawer of the toolbox has been getting all the attention. The skill that matters most, knowing which tool fits the problem, has gone quiet. If your data lives in Db2, much of the toolbox is already there.This session lays the toolbox out on the table. Two axes, what data you have and whether you have labels, organize the AI landscape into a 2×2 you can hold in your head: predictive and unsupervised models for structured data, the same for unstructured data, plus embeddings and generative AI.Then we map every drawer to a Db2 capability you can use today. In-database machine learning for classification, regression, and clustering. Native vector storage and similarity search. Built-in integration with external embedding and language models. Python frameworks for retrieval-augmented applications and AI agents. We close with production patterns we've seen ship, across the full range of model types and use cases.Whether you live in SQL or Python, you'll leave knowing which tool to reach for, and where to start.

Speakers

Shaikh Quader

AI Architect and Master Inventor, IBM Db2, IBM

Wednesday October 28, 2026 4:30pm - 5:30pm EDT
Magnificent 4

Track A, Technical Session

Audience All
Subject LUW

4:30pm EDT

B13 | Wrapping up Db2 11.5

Wednesday October 28, 2026 4:30pm - 5:30pm EDT

Magnificent 1

While Db2 12.1 has been out for some time with great new content, most companies are still using Db2 11.5 which has tremendous business value. Prior to upgrading to Db2 12.1 clients should take advantage of what is in 11.5 and get the most ROI with what they already have. In this session we'll go through an overview of the high value capabilities of Db2 11.5 - covering 11.5.0 through 11.5.9. This will include availability, recoverability, performance, warehouse, security, multi-model, AI capabilities and more.

Speakers

Les King

Owner, Professor, Les King Learning, Seneca College

Les King is a part-time professor at multiple Ontario Colleges, offering courses in Mathematics, Programming and Data Management. Les has also been an instructor at the University of Toronto in the Mathematics department. Les effectively draws a connection between what the marketplace... Read More →

Wednesday October 28, 2026 4:30pm - 5:30pm EDT
Magnificent 1

Track B, Technical Session

Audience All
Subject LUW
Area AI GenAI and Machine Learning, Db2 Cloud and Warehouse, Latest and Features LUW

7:00am EDT

9:00am EDT

10:00am EDT

10:20am EDT

10:20am EDT

10:20am EDT

11:30am EDT

11:30am EDT

11:30am EDT

11:30am EDT

12:30pm EDT

2:00pm EDT

2:00pm EDT

2:00pm EDT

2:00pm EDT

2:00pm EDT

2:00pm EDT

3:00pm EDT

4:30pm EDT

4:30pm EDT

4:30pm EDT

Get help with the event