IDUG NA 2026: Full Schedule

In a world powered by Db2, the rapid evolution of AI makes it hard to separate fact from fiction. Are DBAs being replaced? Will AI rewrite COBOL? Can we afford to ignore quantum encryption? Join our session to cut through the noise, demystify the biggest industry myths, and get real answers directly from industry leaders. Bring your questions!

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 →

Tracy Hutcheson

Director, Data Management, Broadcom

Namik Hrle

CTO & MSD Fellow, Broadcom

Sponsors

Broadcom

Monday October 26, 2026 9:00am - 10:00am EDT
Triumph C/D

Keynote, Keynote

Audience All

10:00am EDT

Coffee Break

Monday October 26, 2026 10:00am - 10:20am EDT

Triumph C/D

Monday October 26, 2026 10:00am - 10:20am EDT
Triumph C/D

IDUG, Break

Audience All

10:20am EDT

A1 | Spotlight: Db2 for z/OS Trends and Directions

Monday October 26, 2026 10:20am - 10:35am EDT

Magnificent 3

Come to listen to the architects of Db2 for z/OS explain overall strategy, review recent new features delivered in Db2 and also take a look at the future - where Db2 is going and why. We will talk about planning for the next version and you will learn what you need to know and actions you should start to take now to prepare for the future of IBM's flagship database.

Speakers

Haakon Roberts

DE, CTO, IBM

Haakon Roberts is an IBM Distinguished Engineer based at the Silicon Valley Laboratory in San Jose, California. He is the chief architect for Db2 for z/OS and Tools and CTO of IBM z Data & AI. He holds several patents and is a leading expert in database management, data integrity... Read More →

Monday October 26, 2026 10:20am - 10:35am EDT
Magnificent 3

Track A, Db2 Spotlight

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

10:20am EDT

B1 | Db2 LUW Spotlight Session

Monday October 26, 2026 10:20am - 10:35am EDT

Magnificent 1

Hear from the lab leadership on the latest shipped + announced Db2 content, and our perspective and vision for the future. We'll cover key enhancements in the latest modpacks (12.1.4 / 12.1.5) and give you a sneak peak at what's coming in 12.1.6 and beyond.

Speakers

Satya Krishaswamy

Director, Hybrid Data Management Development, IBM

Monday October 26, 2026 10:20am - 10:35am EDT
Magnificent 1

Track B, Db2 Spotlight

Audience All
Subject LUW
Area Latest and Features LUW

10:20am EDT

C1 | Growing the Next Generation of Db2 Professionals: Frameworks for the Future

Monday October 26, 2026 10:20am - 11:20am EDT

Magnificent 4

Organizations running Db2 increasingly face a shortage of experienced administrators while environments grow more complex. This session explores a structured approach to developing new Db2 professionals using guided learning, hands-on labs, and coaching from experienced practitioners. We’ll share lessons learned from building scalable training models that accelerate time-to-productivity for new Db2 administrators.

Speakers

Mark Bylok

IBM Systems Tech Training Manager, IBM

Mark Bylok leads IBM Systems Training programs focused on developing technical skills for enterprise platforms including IBM Z, Power, and Storage. His work centers on building scalable learning paths, hands-on labs, and mentorship models that accelerate the development of new system... Read More →

Shelly Meierarend

IBM Z and LinuxONE Client & University Academic Global Skills Leader, IBM

Monday October 26, 2026 10:20am - 11:20am EDT
Magnificent 4

Track C, Special Interest Group

Audience All
Subject z/OS
Area User Stories

10:20am EDT

IDUG Db2 for LUW Essentials

Monday October 26, 2026 10:20am - 5:30pm EDT

Magnificent 2C

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 →

Sponsors

LearnQuest

Monday October 26, 2026 10:20am - 5:30pm EDT
Magnificent 2C

Essentials, Essentials

Audience Beginner
Subject LUW

10:20am EDT

IDUG Db2 for z/OS Essentials

Monday October 26, 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

Monday October 26, 2026 10:20am - 5:30pm EDT
Magnificent 2A

Essentials, Essentials

Audience Beginner
Subject z/OS

11:30am EDT

A2 | What’s New in Db2 for z/OS Performance

Monday October 26, 2026 11:30am - 12:30pm EDT

Magnificent 3

Db2 for z/OS continues to advance through continuous delivery, introducing functional and performance enhancements that improves application availability, compatibility and operational efficiency. Effectively exploiting these capabilities requires understanding not only what has changed, but how the changes interact with workloads, subsystem configuration, and the underlying IBM Z platform.
This session provides a technical deep dive into recent Db2 for z/OS feature enhancements, and how these updates influence performance areas such as CPU consumption, concurrency behavior, and subsystem scalability. It will cover applicable monitoring and instrumentation updates and guide the tuning decisions.
Attendees will leave with concrete technical guidance, exploitation considerations, and best practices for applying recent Db2 for z/OS enhancements.

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 →

Monday October 26, 2026 11:30am - 12:30pm EDT
Magnificent 3

Track A, Technical Session

Audience All
Subject z/OS
Area Latest and Features z/OS, Performance and Monitoring

11:30am EDT

B2 | Db2 LUW - Latest from the Lab

Monday October 26, 2026 11:30am - 12:30pm EDT

Magnificent 1

Learn about the latest developments in Db2 ecosystem coming out of the Labs. A refresher on whats been delivered already. A deep dive into the most recently released mod packs. And catch a sneak peak at our future plans.

Speakers

Mike Springgay

STSM Db2 Architect, IBM

Monday October 26, 2026 11:30am - 12:30pm EDT
Magnificent 1

Track B, Technical Session

Audience All
Subject LUW
Area Latest and Features LUW

11:30am EDT

C2 | A 50 Cent tour of DB2

Monday October 26, 2026 11:30am - 12:30pm EDT

Magnificent 4

With fewer schools teaching DB2 for z/OS, it often falls on the DBAs to provide instruction for the programming staff. This is a very basic introduction to DB2 concepts and vocabulary, aimed at the novice user of DB2, or anyone who must train novice users.

Speakers

Mark McNary

DBA, umb bank n.a.uu

I have been working with DB2 since 1989 in a variety of positions, from heads-down development, to systems design to database design and DBA work. . I love to talk about databases in general, and especially DB2. I also have extensive experience with Oracle, SQL Server, and Sybase... Read More →

Monday October 26, 2026 11:30am - 12:30pm EDT
Magnificent 4

Track C, Technical Session

Audience All
Subject z/OS
Area Back to Basics, User Stories

11:30am EDT

D2 | Db2 Practically Speaking: 40 Years in the Trenches

Monday October 26, 2026 11:30am - 12:30pm EDT

Magnificent 5

In this engaging and experience-rich session, Craig Mullins shares hard-earned lessons from four decades working with Db2 in real-world environments. The session goes beyond theory to explore what actually works—and what doesn’t—when managing, tuning, and evolving mission-critical Db2 systems and applications. Drawing on stories from the field, Craig highlights key pitfalls, performance insights, and practical strategies that have stood the test of time, offering attendees actionable guidance they can apply immediately in today’s complex data landscape.
In essense, this session is a walkthrough of things I have learned throughout my career as a developer, a DBA, an industry analyst, and a consultant. It will discuss best practices and experiences with an eye toward offering practical advice for all Db2 practitioners.

Speakers

Craig Mullins

Principal Consultant, Mullins Consulting, Inc.

Craig S. Mullins is a data management strategist, researcher, and consultant with over four decades of experience with database systems. He is president and principal consultant of Mullins Consulting, Inc. focusing on mainframe, data, and database issues. He has worked with Db2 since... Read More →

Monday October 26, 2026 11:30am - 12:30pm EDT
Magnificent 5

Track D, Technical Session

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

11:30am EDT

E2 | Conversations with IBM Bob On Database Modernisation

Monday October 26, 2026 11:30am - 12:30pm EDT

Magnificent 6

IBM Bob makes a huge difference to understanding, modernising and administering systems developed with Db2 (both LUW and z/OS) as the underlying database. I will talk about my real-world experiences bringing IBM Bob into my workflow and the benefits it made in terms of efficiency and quality of the outcomes. I will also explain why I turned from an AI sceptic to enthusiast once I got hold of the right tools.
After struggling to get value out of other AI assistants when modernising and administering Db2 applications (both LUW and z/OS), I turned to IBM Bob when it became available. Having become an "AI assistant cynic" I quickly became a real enthusiast. IBM Bob understands the technology I am working with and provides real value, but in a way that leaves me always in control. This presentation describes my journey from initial experimentation to real world business value. I'll describe how IBM Bob facilitated system understanding, assisted with structural change and application modernisation.

Speakers

Philip Nelson

Senior Database Software Engineer, Lloyds Banking Group / ScotDB Limited

Philip Nelson has worked with Db2 since 1989. He likes to explore new functionality and is always exploring new techniques for enhancing Db2 usage. He is a frequent presenter at IDUG and has also supported IDUG in many other ways, including the IDUG EMEA CPC and the Content Commi... Read More →

Monday October 26, 2026 11:30am - 12:30pm EDT
Magnificent 6

Track E, Technical Session

Audience All
Subject Cross Platform
Area Modernization in Development, User Stories

11:30am EDT

F2 | Introduction to SQL-PL

Monday October 26, 2026 11:30am - 12:30pm EDT

Magnificent 7

In this session, we'll go back to basics and look at SQL-PL, Db2's built in server-side application logic. We'll take a look at the code constructs and how to leverage in stored procedures, user defined functions and triggers. We'll also look at more complex scenarios like code for a Data Partitioning Feature (DPF) environment. The majority of this session will be looking at and executing source code.

Speakers

Les King

Owner, Professor, Les King Learning, Seneca College

Monday October 26, 2026 11:30am - 12:30pm EDT
Magnificent 7

Track F, Technical Session

Audience Beginner
Subject LUW
Area AppDev, Back to Basics, Modernization in Development, Working with SQL

12:30pm EDT

Lunch

Monday October 26, 2026 12:30pm - 2:00pm EDT

Triumph C/D

Monday October 26, 2026 12:30pm - 2:00pm EDT
Triumph C/D

IDUG, Lunch

Audience All

2:00pm EDT

A3 | Db2 for z/OS Utilities - What's New?

Monday October 26, 2026 2:00pm - 3:00pm EDT

Magnificent 3

There have been several useful enhancements made in Db2 for z/OS utilities in recent years. This session will explain what has been delivered and how best to take advantage of these new features. We will also provide some insight into future plans leading up to the next version of Db2.

Speakers

Haakon Roberts

DE, CTO, IBM

Parker Weber

Senior developer, Rocket Software

Parker Weber is a senior developer within the Db2 for z/OS utilities team with primary responsibility for the REORG utility - the utility that is of crucial importance and central to Db2's online schema strategy.

Monday October 26, 2026 2:00pm - 3:00pm EDT
Magnificent 3

Track A, Technical Session

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

2:00pm EDT

B3 | Db2 LUW V12: New Security Features and Changes

Monday October 26, 2026 2:00pm - 3:00pm EDT

Magnificent 1

This session will cover the new features in Db2 12.1 security, covering 12.1.3, 12.1.4 and 12.1.5. Attend to hear about new auditing capabilities, including audit to cloud object storage, and directly to CSV files. You will also learn about new JWT authentication enhancements features online key retrieval. 12.1.5 sees the completion of the reduce file permission feature started in 12.1.2 that really locks down a Db2 instance. You will also hear about new Quantum Safe Crypto support in TLS.

Speakers

Greg Stager

Senior Software Developer, DB2 Engine Development - Security, IBM

Monday October 26, 2026 2:00pm - 3:00pm EDT
Magnificent 1

Track B, Technical Session

Audience All
Subject LUW
Area Latest and Features LUW, Security and Compliance

2:00pm EDT

C3 | Challenges for the Successful Db2 13 Lock Structure Async Duplex Implementation at Itaú Unibanco

Monday October 26, 2026 2:00pm - 3:00pm EDT

Magnificent 4

Ensuring high availability and resilience is a core requirement for modern enterprise data platforms. In Db2 Data Sharing environments, lock structures are a fundamental component for maintaining system stability and consistent performance under continuous, mission-critical workloads.
At Itaú Unibanco S.A., Db2 for z/OS supports essential banking applications operating 24x7, across transactional and batch workloads in a large-scale production environment. As part of its ongoing resilience and architecture evolution strategy, Itaú adopted the Db2 Lock Structure Asynchronous Duplex capability.
This implementation strengthened the platform’s resilience posture by increasing fault tolerance, enhancing operational continuity during infrastructure maintenance, and reinforcing overall system stability.
In this presentation, specialists from Itaú and IBM share practical insights from the initiative, including architectural motivations, implementation considerations, testing approaches, and results achieved. The discussion highlights how close collaboration between client and vendor supported the successful adoption of advanced Db2 z/OS capabilities in a complex enterprise environment.

Speakers

Paulo Rogério Petrachini

Db2 z/OS Specialist, Banco Itaú Unibanco S.A.

Paulo Rogério Petrachini has worked with Db2 z/OS for over 30 years, acting both as a Systems Programmer and DBA in large private banks in Brazil, which have complex and heavy Db2 mission-critical workloads processing in data-sharing groups.

José Eduardo Pol

IBM Certified Expert Technical Specialist & IBM Premium Support, IBM Brasil

José Eduardo Pol, is a consulting IT specialist certificated, with over 30 years of experience working at IBM Brazil supporting clients in a variety of subject in Db2 for z/OS area. Currently works as Db2 for z/OS IBM Premium Support for a large Bank in Brazil acting as focal point... Read More →

Monday October 26, 2026 2:00pm - 3:00pm EDT
Magnificent 4

Track C, Technical Session

Audience All
Subject z/OS
Area Database Resiliency, User Stories

2:00pm EDT

D3 | SQL for the 21st Century

Monday October 26, 2026 2:00pm - 3:00pm EDT

Magnificent 5

Make sure you have all the tools to write functional SQL using all the features of recent versions of Db2. Stop writing SQL like it's the '90s.

Speakers

David Simpson

Principal Platform Engineer for Db2, Huntington Bank

David has been a developer, DBA, consultant and Db2 sysprog since 1993. He especially loves helping others become proficient in his favorite technology, Db2!

Monday October 26, 2026 2:00pm - 3:00pm EDT
Magnificent 5

Track D, Technical Session

Audience Intermediate
Subject Cross Platform
Area Best Practices, Latest and Features LUW, Latest and Features z/OS, Working with SQL

2:00pm EDT

E3 | Amazon RDS for Db2 Service Deep Dive: Architecture, Operations, and Best Practices

Monday October 26, 2026 2:00pm - 3:00pm EDT

Magnificent 6

Amazon RDS for Db2 addresses growing demand for Db2 cloud migration by delivering a fully managed service with push-button deployment — provision a production-ready Db2 instance in minutes, not days. Automated patching, backups, scaling, and failover eliminate undifferentiated heavy lifting. This deep dive covers RDS for Db2 through the Well-Architected Framework: Operational Excellence, Security, Reliability, Performance Efficiency, and Cost Optimization. Attendees learn how a managed service reduces admin burden, improves uptime, and frees teams to focus on innovation. Leave with a blueprint for modernizing Db2.
Self-managed Db2 means manual patching, complex HA, and rising costs. Amazon RDS for Db2 fixes that — deploy production-ready Db2 in minutes with a fully managed service.This deep dive covers RDS for Db2 through the Well-Architected Framework: Operational Excellence (automated patching, backups, monitoring), Security (encryption, IAM, VPC), Reliability (Multi-AZ, cross-region DR), Performance Efficiency (right-sizing, storage tuning), and Cost Optimization (Reserved Instances, TCO savings vs. self-managed).Live demos and customer patterns show how to provision, secure, and optimize RDS for Db2 for production. Migrating from Linux or AIX? Optimizing an existing deployment? Leave with a well-architected blueprint for Db2 as a managed service on AWS.

Speakers

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 →

Monday October 26, 2026 2:00pm - 3:00pm EDT
Magnificent 6

Track E, Technical Session

Audience All
Subject LUW
Area Back to Basics, Best Practices, Modernization in Operations

2:00pm EDT

F3 | Debugging SQL PL - Without a Debugger

Monday October 26, 2026 2:00pm - 3:00pm EDT

Magnificent 7

Db2 enables developers to write Procedures, Functions, and Triggers using SQL PL (SQL Procedure Language). While IBM does provide a debugger that can be used to debug SQL PL, users may not want to run a debugger in production. This session will explore alternatives to using the Unified Debugger. At the end of this session, you should be able to use the techniques discussed in this presentation to Debug an SQL PL application (Procedure, Function, or Trigger).

Speakers

Chris Crone

Distinguished Engineer, Broadcom

Chris is a Distinguished Engineer for Database Technology and a lead architectfor the Data Management portfolio within the Mainframe Division of BroadcomSoftware Group. He oversees strategy and architecture decisions for theBroadcom database products IDMS and Datacom, as well as for... Read More →

Monday October 26, 2026 2:00pm - 3:00pm EDT
Magnificent 7

Track F, Technical Session

Audience All
Subject z/OS
Area AppDev, Back to Basics, Working with SQL

2:00pm EDT

IDUG Badging

Monday October 26, 2026 2:00pm - 5:00pm EDT

Magnificent 2B

Sponsors

IDUG

Monday October 26, 2026 2:00pm - 5:00pm EDT
Magnificent 2B

Badging, Certification & Badging

Audience All
Subject LUW

3:00pm EDT

Coffee Break

Monday October 26, 2026 3:00pm - 3:20pm EDT

Triumph C/D

Monday October 26, 2026 3:00pm - 3:20pm EDT
Triumph C/D

IDUG, Break

Audience All

3:20pm EDT

A4 | JC Greatest Hits, War Stories and Best Practice 2026

Monday October 26, 2026 3:20pm - 4:20pm EDT

Magnificent 3

This session will share experience from client studies and engagements: sharing proven recommended best practice; learning good, bad and ugly; providing answers ti important, frqeeunt or difficuly questions. This session will cover the following topics: Complacency about component failure and ability to absorb workload failover in a dat asharing environment; missed opportinity for elapsed time performance improvementnfor skip sequnetial batch processing; misteps in evaluating the performance benenfit of CICS-Db2 thread reuse and RELEASE(DEALLOCATE); SQL coding to avoid update anomaly when using cursor stability isolation; misadventures when using High Performance DBATs;monitoring WLM policy achievement; options for mass data recovery following logical data recovery and data loss; performance issue with remote DDF batch workload; tuning ogf GBPs; thorough Disaster Restart testing.

Speakers

John Campbell

Distinguished Technical Consultant, Broadcom

Monday October 26, 2026 3:20pm - 4:20pm EDT
Magnificent 3

Track A, Technical Session

Audience All
Subject z/OS
Area Best Practices, Database Resiliency, Latest and Features z/OS, Performance and Monitoring, User Stories

3:20pm EDT

B4 | Accelerating AI Workloads in Db2 v12.1.5.0: Introducing High‑Performance Vector Indexes

Monday October 26, 2026 3:20pm - 4:20pm EDT

Magnificent 1

Discover how Db2’s new DiskANN‑powered vector index delivers fast, scalable similarity search while integrating seamlessly into existing database workflows. We’ll walk through expected performance gains using AWS benchmark results and share practical tuning strategies to help you get the most out of vector search in Db2.

Speakers

Christian Garcia-Arellano

STSM, Db2 Senior Architect and Master Inventor, IBM

Christian Garcia-Arellano is STSM and Db2 OLTP Architect at the IBM Toronto Lab, and has a MSc in Computer Science from the University of Toronto. Christian has been working in various DB2 Kernel development areas since 2001. Initially Christian worked on the development of the self... Read More →

Monday October 26, 2026 3:20pm - 4:20pm EDT
Magnificent 1

Track B, Technical Session

Audience Intermediate
Subject LUW
Area AI GenAI and Machine Learning, AppDev, Latest and Features LUW, Modernization in Development

3:20pm EDT

C4 | Enabling Mainframe Data for Next-Gen Innovation

Monday October 26, 2026 3:20pm - 4:20pm EDT

Magnificent 4

The future of enterprise innovation depends on unlocking the full potential of your mainframe data. Today, critical business data is siloed across Db2, IMS, VSAM, and other legacy sources slowing progress and consuming up to 80% of analysts’ time in preparation instead of insight. Traditional ETL and data warehouses can’t keep pace with the demands of real-time analytics, AI, and cloud-native applications.
This session explores how a unified data virtualization layer connects your mainframe data to the digital ecosystem—securely, instantly, and without costly replication. Imagine real-time access to all your enterprise data through RESTful APIs, JDBC, ODBC, and SQL—fueling advanced analytics, machine learning, and next-gen applications.
Join us to explore how your organization can move beyond silos and embrace a future of agility, speed, and innovation. The next era of data-driven transformation starts now—are you ready?

Speakers

Jim Wankowski

Principal Solutions Advisor, Rocket Software

Jim Wankowski is an accomplished technology leader and Principal Solutions Advisor at Rocket Software, specializing in IBM Data Virtualization Manager for z/OS (DVM) and OMEGAMON AI for Db2. As the global lead technical resource for DVM, Jim partners with major enterprises worldwide... Read More →

Monday October 26, 2026 3:20pm - 4:20pm EDT
Magnificent 4

Track C, Technical Session

Audience All
Subject z/OS
Area Data Movement and Integration, Modernization in Development

3:20pm EDT

D4 | A Modern Approach to Db2 Backup & Recovery: Snapshot Technology with Cloud Integration

Monday October 26, 2026 3:20pm - 4:20pm EDT

Magnificent 5

This session presents a comprehensive approach to database backup and recovery using Snapshot Backup technology integrated with Cloud infrastructure. The solution leverages the Db2 ACS Scripted interface to automate backup operations on Linux systems, enabling efficient data protection strategies for enterprise databases. The implementation utilizes Linux LVM (Logical Volume Manager) to create consistent point-in-time snapshots of database volumes, ensuring data integrity during backup operations. By combining snapshot-based backup techniques with cloud object storage capabilities, this approach delivers a robust disaster recovery solution that minimizes backup windows, reduces storage costs, and enhances data availability. The scripted automation through Db2 ACS interface ensures consistent, repeatable backup procedures while maintaining operational efficiency in Linux environments. This methodology addresses critical requirements for modern database management, including rapid recovery time objectives (RTO), minimal recovery point objectives (RPO), and compliance with data retention policies through cloud-based archival strategies.

Speakers

Thomas Rech

Architect Db2 SAP Dev. & Client Adoption Engineering, IBM

Monday October 26, 2026 3:20pm - 4:20pm EDT
Magnificent 5

Track D, Technical Session

Audience Intermediate
Subject LUW
Area Automation, Back to Basics, Db2 Cloud and Warehouse, Modernization in Operations, Utilities

3:20pm EDT

E4 | Accelerating AI Adoption on Db2 with Industry Starter Kits

Monday October 26, 2026 3:20pm - 4:20pm EDT

Magnificent 6

Interested in exploring IBM SQL Data Insights without the effort of installing it on your system or building models from scratch? This session introduces Industry Starter Kits designed to help Db2 for z/OS users quickly evaluate and experience the power of AI-driven insights using pre-built models, sample industry data, and ready-to-run AI queries.
The session features real-world use cases across industries such as finance and insurance, demonstrating how SQL Data Insights can analyze Db2 table data to uncover hidden relationships, detect anomalies, identify unusual transactions, and generate meaningful business insights that may be difficult to find using traditional SQL techniques alone. Attendees will learn how to deploy and load pre-built AI models, execute AI-driven SQL queries, and understand and interpret the results returned by those queries using familiar Db2 workflows and interfaces.
By walking through the industry use cases included in the starter kits, attendees will gain a clearer understanding of what SQL Data Insights is capable of and how AI-driven SQL analysis can be applied to their own Db2 environments. The session is intended to spark ideas for new use cases and help users envision how their existing Db2 data can be analyzed in entirely new ways.
Whether you are new to SQL Data Insights or looking for an easier way to get started, this session provides a practical, hands-on approach to jump-starting your AI journey on Db2 for z/OS.

Speakers

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 →

Monday October 26, 2026 3:20pm - 4:20pm EDT
Magnificent 6

Track E, Technical Session

Audience Beginner
Subject z/OS
Area AI GenAI and Machine Learning, AppDev, Latest and Features z/OS

3:20pm EDT

F4 | SQL Oldies but Goodies and the Power of the SQL Rewrite

Monday October 26, 2026 3:20pm - 4:20pm EDT

Magnificent 7

There have been so many enhancements in Db2 SQL for developers in the last 3 or 4 versions that many developers have never really taken advantage of. This presentation picks my personal favorites that I believe all developers should get knowledgeable on and possibly applied to current and future applications. Developers should be informed of all of newer features in Db2 and this presentation is a great summary for this topic. When it comes to performance, often times the answer to better performance is rewriting queries different ways, and redesigning programs differently. Attendees will leave with a better understanding of some great SQL enhancements, application table designs, along with getting stronger in the SQL language. This is a great session for developers on Db2 LUW or Db2 z/OS. Developers 'Get Empowered'.

Speakers

Tony Andrews

Mainframe developer, Db2 SQL Performance and Tuning, Db2 trainer, P&T Solutions, Inc.

Tony Andrews has more than 30 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... Read More →

Monday October 26, 2026 3:20pm - 4:20pm EDT
Magnificent 7

Track F, Technical Session

Audience All
Subject Cross Platform
Area AppDev, Back to Basics, Best Practices, Latest and Features z/OS, Working with SQL

4:30pm EDT

A5 | Ready Player One? Db2 vNext Migration (Made Easy)

Monday October 26, 2026 4:30pm - 5:30pm EDT

Magnificent 3

Are you, and all of your sub-systems, ready for Db2 vNext that is coming to an enterprise near you soon? Are you aware that you cannot even get to Db2 13 FL511 if you have any of the specially announced “deprecated” items that we all have hanging around? Do you have a plan to get you out of this mess?
This session explains how you can find all the migration blockers that exist in your system and how to fix nearly all of them as well. It will also delve into VTAM/SNA and workfile usage to round off everything that can bite you!

Speakers

Roy Boxwell

Senior Software Architect, Software Engineering GmbH

I am an IBM Champion with more than 38 years of experience in MVS, OS/390, and z/OS environments – 37 of those in Db2. He specializes in installation, migration, and performance monitoring and tuning. Roy leads the SEG development team responsible for the real-time database maintenance... Read More →

Monday October 26, 2026 4:30pm - 5:30pm EDT
Magnificent 3

Track A, Technical Session

Audience Intermediate
Subject z/OS
Area Latest and Features z/OS, Security and Compliance, Working with SQL

4:30pm EDT

B5 | Introducing Db2 Serverless - the database service for the AI Era

Monday October 26, 2026 4:30pm - 5:30pm EDT

Magnificent 1

In this session we will show you how application building with a serverless database gives you superpowers. Serverless databases are built for the AI Era handling the workloads of the future and turning you into a 10X Engineer. We will show you how to develop applications for Db2 from prompt to production and demonstrate how a serverless database tackles AI and Machine driven workloads all while reducing cost and effort. Join us for this groundbreaking session and experience the future of Db2 SaaS services!

Speakers

Andrew Hilden

Chief Architect Db2 SaaS, IBM

Monday October 26, 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, Modernization in Development

4:30pm EDT

C5 | Common made performance mistakes, when coding SQL

Monday October 26, 2026 4:30pm - 5:30pm EDT

Magnificent 4

The blessing of SQL is: when logically correct it will return an answer. Unfortunately, this is also the curse. Depending on how you write your SQL, you give the optimizer more or fewer choices .In this session we will go over understanding performance basics and common made SQL mistakes and the impact they have on the optimizer's choices.
Bring our application DBA's and developers to this session to train them and avoid common SQL performance pitfalls

Speakers

Kurt Struyf

consultant, lone-star

Kurt Struyf is an independent consultant/contractor and president of Lone Star consulting. He has over 25 years experience as a (system) DBA and has been installing, migrating, troubleshooting and tuning DB2 systems throughout Europe. Besides his consultancy missions he has been teaching... Read More →

Monday October 26, 2026 4:30pm - 5:30pm EDT
Magnificent 4

Track C, Technical Session

Audience Beginner
Subject AppDev
Area AppDev, Back to Basics, Best Practices, Performance and Monitoring, Working with SQL

4:30pm EDT

D5 | DBA 2.0 - Making Change the DBA's Advantage

Monday October 26, 2026 4:30pm - 5:30pm EDT

Magnificent 5

The role of the DBA has evolved over the years. As businesses across the globe embrace digital transformation, and customer expectations increase, the traditional rules of engagement must be reconsidered, and the DBA remains a key lynch-pin in the Agile journey to DevOps. This presentation will review the old rules of engagement, and express the importance of communication, trust, embracing change, and automation tools in modern software development in the age of AI.

Speakers

Marcus Davage

Lead Product Developer, BMC Software Ltd

I’m a senior engineering leader with more than 35 years working across IBM Z, Db2 for z/OS, and large‑scale enterprise systems — helping organisations cut cost, reduce risk, and modernise. My career has focused on solving the kinds of performance, scalability, and architectural... Read More →

Monday October 26, 2026 4:30pm - 5:30pm EDT
Magnificent 5

Track D, Technical Session

Audience All
Subject z/OS
Area AI GenAI and Machine Learning, AppDev, Automation, Modernization in Development, Modernization in Operations

4:30pm EDT

E5 | Db2 is Your AI Platform: Five Proven AI Use Cases to Build Right Now

Monday October 26, 2026 4:30pm - 5:30pm EDT

Magnificent 6

Db2 now has a complete AI application stack — Vector Storage, Vector Similarity Search, Vector Index, and LLM Integration. Once you know what this stack can do, the natural next question is: what can you build with it? That is exactly what this session addresses. Drawing on industry research and global enterprise adoption data, we examine AI use cases that organisations have already deployed at scale and validated in production. For each, we explain the business problem it solves, how Db2's AI stack maps to the solution, and what implementation looks like — using data most Db2 customers already have. Business leaders will leave with a clear, evidence-backed starting point for AI investment. Developers and architects will leave with a concrete path from proven use case to working implementation. The stack is ready. The use cases are proven. Come find out which ones to build next.

Speakers

Shaikh Quader

AI Architect and Master Inventor, IBM Db2, IBM

Monday October 26, 2026 4:30pm - 5:30pm EDT
Magnificent 6

Track E, Technical Session

Audience Intermediate
Subject LUW
Area AI GenAI and Machine Learning, AppDev

4:30pm EDT

F5 | You should concentrate (your literals) - Dynamic SQL performance tips

Monday October 26, 2026 4:30pm - 5:30pm EDT

Magnificent 7

In today's world, dynamic SQL usage is on the rise.The presentation will show ways to enhance dynamic SQL performance,Focusing on CSWL feature with actual big savings achieved.Skeleton:Dynamic vs static SQL Literals vs parameter markersDSC Cost vs benefit LimitationsCSWL How does it work Cost vs benefit Where can I use it Real life savings from mataf Limitations Should I use it globally?

Speakers

Shay Miller

DBA, FIBI

I'm a DBA of DB2 for zOS for 25 years, both system DBA and application DBA.I've worked as a DBA in the IDF and for the last 18 years in FIBI.
I've attended IDUG EMEA 2015 at Dublin.I've attended and presented a session in IDUG NA 2024 at Charlotte.
I hold the following IBM certif... Read More →

Monday October 26, 2026 4:30pm - 5:30pm EDT
Magnificent 7

Track F, Technical Session

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

5:30pm EDT

IDUG Welcome Reception

Monday October 26, 2026 5:30pm - 7:00pm EDT

Triumph C/D

Monday October 26, 2026 5:30pm - 7:00pm EDT
Triumph C/D

IDUG, Reception

Audience All

7:30am EDT

8:45am EDT

9:00am EDT

10:00am EDT

10:20am EDT

10:20am EDT

10:20am EDT

10:20am EDT

10:20am EDT

11:30am EDT

11:30am 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

2:00pm EDT

3:00pm EDT

3:20pm EDT

3:20pm EDT

3:20pm EDT

3:20pm EDT

3:20pm EDT

3:20pm EDT

4:30pm EDT

4:30pm EDT

4:30pm EDT

4:30pm EDT

4:30pm EDT

4:30pm EDT

5:30pm EDT

Get help with the event