Loading…
Monday, October 26
 

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
avatar for Craig Mullins

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

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
avatar for Les King

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 →
Monday October 26, 2026 11:30am - 12:30pm EDT
Magnificent 7
  Track F, Technical Session

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
avatar for David Simpson

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

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
avatar for Chris Crone

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

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
avatar for Tony Andrews

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

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
avatar for Roy Boxwell

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

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
avatar for Kurt Struyf

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

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
avatar for Shay Miller

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
 
Tuesday, October 27
 

10:20am EDT

F6 | Modern React Backend Testing: Replacing Fragile Mocks with SQLite for Db2‑Backed APIs
Tuesday October 27, 2026 10:20am - 11:20am EDT
Magnificent 7
Modern engineering teams move fast, but brittle tests, flaky mocks, and sluggish integration pipelines can slow even the strongest React + Node backends to a crawl. Database testing is often the first casualty—SQL tests get skipped because they require a persistent Db2 instance, complicating CI/CD and slowing development. This session presents a battle‑tested alternative: using SQLite as an ephemeral, SQL‑compatible stand‑in for Db2 to deliver fast, reliable, production‑like backend tests. You’ll learn how to spin up isolated in‑memory databases, seed realistic data, run true end‑to‑end API tests, and automate teardown without touching production infrastructure. We’ll cover schema alignment, SQL‑driven test design, and strategies for keeping tests blazing fast as your backend grows. If you want to test backend logic as it actually runs—not as mocks pretend it runs—this talk will give you the practical patterns and real‑world insights to elevate your testing strategy and ship with confidence.
Speakers
avatar for David Morris

David Morris

Solutions Architect, Leidos
Highly regarded engineering leader, specializing in IT modernization with a proven track record in driving strategic IT governance and architectural transformation for federal agencies. Expert in developing and implementing enterprise reference architectures, enhancing data protection... Read More →
Tuesday October 27, 2026 10:20am - 11:20am EDT
Magnificent 7
  Track F, Technical Session

4:30pm EDT

B9 | Db2: Explain EXPLAIN
Tuesday October 27, 2026 4:30pm - 5:30pm EDT
Magnificent 1
Technical details to Db2 LUW usage and optimization of queries
There are many sessions about the EXPLAIN facility in Db2 LUW, but they all lack the concise statements to find the right SQL queries, set everything up, do the EXPLAIN and draw the right conclusions by examples and working statements to copy-and-paste.This is a back-to-basics session, enhanced with experiences from real situations and best practices.This session was presented at IDUG NA 2025 in Atlanta. It was in the Top10 of the user sessions. I will update the material to version 12.1 and preferrably include details regaring AI optimizer
Speakers
avatar for Roland Schock

Roland Schock

Principal, tasdevil Consulting
Roland is installing, using and tuning Db2 on distributed since 1993 or Version 2.1 for OS/2. After working for 25+ years for ARS Computer und Consulting GmbH as a Db2 expert he is now an independent consultant.His expertise and engagement for the community allowed him to be IBM Champion... Read More →
Tuesday October 27, 2026 4:30pm - 5:30pm EDT
Magnificent 1
  Track B, Technical Session
 
Wednesday, October 28
 

10:20am EDT

A10 | Revisiting Parallelism: Targeted Use of zIIP Processors for Db2 Queries
Wednesday October 28, 2026 10:20am - 11:20am EDT
Magnificent 3
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
avatar for Thomas Baumann

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

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
avatar for Akiko Hoshikawa

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 →
JL

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.
avatar for Catherine Wu

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

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
avatar for Sheryl Larsen

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
 
Thursday, October 29
 

10:20am EDT

B15 | Advanced Performance Diagnostics for SQL
Thursday October 29, 2026 10:20am - 10:20am EDT
Magnificent 1
The Db2 family of products including Db2, Db2 Warehouse, and Db2 PureScale provide a number of important features for diagnosing and solving your SQL problems. Through a series of practical examples, this session will bring you up speed on the latest capabilities available for SQL diagnostics and show you how you can leverage them to solve query problems in your own environment. You will learn how to identify your most expensive SQL statements using the package cache table functions, and how to use Db2's "time spent" metrics to analyze where your problem queries are spending their time. You will also learn some new tips for monitoring sort memory metrics and query memory consumption in order to tune your analytic workloads. Finally you will learn how to use the runtime explain capabilities in conjunction with the activity event monitor to capture actual query plan cardinalities as well the per object metrics.
Speakers
avatar for David Kalmuk

David Kalmuk

Distinguished Engineer, Databases, IBM

Thursday October 29, 2026 10:20am - 10:20am EDT
Magnificent 1
  Track B, Technical Session

10:20am EDT

D15 | Db2 Z and the CIA
Thursday October 29, 2026 10:20am - 11:20am EDT
Magnificent 5
Db2 Z and the CIA is a powerful informational combination. To be clear, the CIA is the Compliance Information Analysis product available for free to many users of Db2 Z (if you have Broadcom products). Broadcom introduced the CIA as a subproduct of ACF2. It is now an independent product available to most users of their products. The CIA provides a series of Db2 tables that can contain all the information from your external-security-manager (ESM), whether it is ACF2, RACF, or TopSecret. Once your ESM is loaded into the CIA, it is relatively more accessible to the curious end-user! SQL SELECT can be used to easily build interesting and useful and focused reports about your security configuration. This presentation will go over the basics of mainframe security and the basics of the CIA and how to build and populate. Finally, interesting CIA tables and views (and sample SELECTs) will be highlighted to show why it is useful.
Speakers
avatar for Brian Laube

Brian Laube

Db2 DBA, Manulife Financial
Brian Laube is an application DBA for Db2 Z working for Manulife Financial in Canada. Brian has experience with performance monitoring, SQL, application developement, security and everything else in the mainframe world.
Brian has been an IBM Champion since 2017. Brian is one of the directors of the Central Canada Db2 User Group which still holds an annual TWO day in-person user-group event! Brian Laube has presented at many IDUG conferences since 2015 in both NA and EMA. Brian is a volunteer with... Read More →
Thursday October 29, 2026 10:20am - 11:20am EDT
Magnificent 5
  Track D, Technical Session

3:45pm EDT

C202 | The Hidden Mistakes That Hurt Db2 for z/OS Query Performance
Thursday October 29, 2026 3:45pm - 5:15pm EDT
Magnificent 4
Even well‑written SQL can slow Db2 for z/OS when subtle mistakes slip through. In this hands‑on lab, attendees will work with preloaded queries that showcase common pitfalls—over‑indexing, missing or stale statistics, inefficient joins, unnecessary sorting, and predicate mismatches. You’ll identify the issues, apply targeted fixes, and validate improvements using metrics, access path analysis, and supporting tools.
Beyond immediate speedups, this lab reinforces a repeatable diagnostic approach that strengthens day‑to‑day tuning and sets the stage for AI‑assisted operations—where consistent, high‑quality data enables smarter automation and more reliable outcomes.
Speakers
avatar for Carlos Davis

Carlos Davis

Solutions Advisor, Rocket Software
Carlos Davis is a Solutions Advisor at Rocket Software with more than 20 years of hands-on experience powering mission critical Db2 environments across a wide range of industries. As a trusted advisor to his clients, he helps organizations maximize performance, minimize risk, and... Read More →
Sponsors
R
Thursday October 29, 2026 3:45pm - 5:15pm EDT
Magnificent 4
  Track C, Hands-On Lab

3:45pm EDT

F202 | Bridging Structured and Unstructured Data: Hybrid AI Queries with Db2
Thursday October 29, 2026 3:45pm - 5:15pm EDT
Magnificent 7
This hands-on lab will explore how Db2 integrates vector data with structured relational data to support AI-driven use cases. Through guided exercises, attendees will combine unstructured text-derived vectors with traditional data and apply similarity search across both. The lab shows queries that merge SQL filtering with vector similarity to enable semantic search, recommendations, and intelligent data retrieval.
Speakers
avatar for Wilfried Hoge

Wilfried Hoge

Senior Customer Success Engineer Data Platform, IBM
Wilfried Hoge is an IT Architect for Data Platforms at IBM, where he leads data platform solutions for the public sector in Germany. As a technical expert, he leverages his extensive experience to help organizations build modern data architectures as a reliable foundation for analytics... Read More →
avatar for Andreas Weininger

Andreas Weininger

Principal Information Architecture Technical Specialist, IBM
Andreas Weininger is part of the Information Architecture team of IBM in Munich. He has more than 20 year of experience with scalable solutions for data intensive solutions focussing especially on the performance aspects. He is a regular speaker at database and data warehousing events... Read More →
Sponsors
I
Thursday October 29, 2026 3:45pm - 5:15pm EDT
Magnificent 7
  Track F, Hands-On Lab
 

Get help with the event

Contact event planner Event login
View support guides Find upcoming events
Create an event you'd love to attend!
Explore why organizers choose Sched • Success stories
Event App • Event scheduling • Event registration • Event ticketing • Sched forms • Call for papers • Badges • Conferences
© 2026. SCHED LLC - All rights reserved - Helping events since 2008
Conference Scheduling Software • Privacy • Terms
Share Modal

Share this link via

Or copy link

Filter sessions
Apply filters to sessions.
Monday, October 26
Tuesday, October 27
Wednesday, October 28
Thursday, October 29
IBM TechXchange
Magnificent 1
Magnificent 2A
Magnificent 2B
Magnificent 2C
Magnificent 3
Magnificent 4
Magnificent 5
Magnificent 6
Magnificent 7
Magnificent Foyer
Triumph A/B
Triumph C/D
  • Badging
  • Essentials
  • Expert Panel
  • IDUG
  • Keynote
  • Track A
  • Track B
  • Track C
  • Track D
  • Track E
  • Track F
  • Audience
  • All
  • Beginner
  • Intermediate
  • Subject
  • AI / ML
  • AppDev
  • Cross Platform
  • LUW
  • z/OS
  • Area
  • AI GenAI and Machine Learning
  • AppDev
  • Automation
  • Back to Basics
  • Best Practices
  • Data Movement and Analytics
  • Data Movement and Integration
  • Database Resiliency
  • Db2 Cloud and Warehouse
  • Latest and Features LUW
  • Latest and Features z/OS
  • Modernization in Development
  • Modernization in Operations
  • Performance and Monitoring
  • Security and Compliance
  • User Stories
  • Utilities
  • Working with SQL