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

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

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
avatar for Ashish Prasad

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

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
avatar for John Campbell

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 →
Monday October 26, 2026 3:20pm - 4:20pm EDT
Magnificent 3
  Track A, 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

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

A6 | Z Data Integration Update
Tuesday October 27, 2026 10:20am - 11:20am EDT
Magnificent 3
This session is about deep dive technical details of how Z data is integrated with other platforms and solutions. This is an architectural, use case and product level technical session. There will be latest news from the zSW Development and Product Management in the context of Data Management, focused on Db2 for z/OS.
The goal of this session is

What are data modernization Challenges – Past, Present, Future
IBM Z Data and AI Enterprise Architecture
Architectural alternatives to provide Db2 for z/OS data into other platforms for data modernization story
Core Products, Virtualization, Data Integration and AI Techniques
Replicate, Direct Access, Virtualization – Pros & Cons.
Technical and Business Use Cases with Capabilities
Roadmaps and Future direction of IBM
Speakers
avatar for Cuneyt Goksu

Cuneyt Goksu

Executive IT Specialist, IBM
M. Cüneyt Göksu is an Executive IT Specialist for IBM® Z solutions in the context of Data and AI in IBM Germany Development Lab as a member of Center of Excellence team. He holds MBA, bachelor’s degree and PhD in Computer Science. He has been working with Db2 for z/OS and IBM... Read More →
Tuesday October 27, 2026 10:20am - 11:20am EDT
Magnificent 3
  Track A, Technical Session

10:20am EDT

C6 | Mining db2mon
Tuesday October 27, 2026 10:20am - 11:20am EDT
Magnificent 4
The folks at the Db2 Lab provide us with a great tool to monitor Db2. It's free and already installed with Db2. This session will show you how db2mon works and how to use it. Then, we'll discuss how to run it in different ways for different use cases. Next, we'll present a way to run db2mon for historical data gathering and trend analysis. Finally, we'll show examples of the data db2mon provides and what to look for in various performance scenarios.
Speakers
avatar for Ken Shaffer

Ken Shaffer

Db2 Consultant, Aerodata, Inc.
Ken has been a Db2 Consultant for over 20 years, specializing in LUW systems. He has worked on a variety of large databases for large corporate and government clients. Most of these projects have involved deploying and supporting mission-critical applications where constant availability... Read More →
Tuesday October 27, 2026 10:20am - 11:20am EDT
Magnificent 4
  Track C, Technical Session

10:20am EDT

D6 | Db2 z/OS Index Strategy: Architecture, Usage, and Recovery
Tuesday October 27, 2026 10:20am - 11:20am EDT
Magnificent 5
Not all indexes are created equal. We explore the architectural differences between Partitioned, Non-Partitioned (NPSI), and Data-Partitioned (DPSI) indexes and when to deploy each for performance. Crucially, we explore each type's optimal recovery strategy so you can stop guessing between Rebuild and Recover.
Speakers
avatar for Ahmed Hamed

Ahmed Hamed

Software Engineer, Broadcom
Ahmed Hamed is a Software Engineer at Broadcom, specializing in the development and mission-critical support of Db2 Backup and Recovery solutions for z/OS. With nine years of experience in the software industry, the last seven are dedicated to the mainframe ecosystem. Ahmed focuses... Read More →
Tuesday October 27, 2026 10:20am - 11:20am EDT
Magnificent 5
  Track D, Technical Session

10:20am EDT

E6 | Is It the End of DBAs for Db2 for z/OS?
Tuesday October 27, 2026 10:20am - 11:20am EDT
Magnificent 6
For decades, Db2 for z/OS DBAs have served as the platform’s human control plane, balancing availability, performance, recoverability, security, and change at enterprise scale. Today, automation, smarter tooling, and AI-driven recommendations are reshaping that role by reducing repetitive work and accelerating insight. But does that mean the DBA is disappearing?This session examines the past, present, and future of Db2 for z/OS administration to distinguish what can be automated from what still requires human expertise. It explores how autonomics, integrated monitoring, and operational AI are moving DBAs from manual execution toward policy, architecture, governance, and decision-making.Attendees will gain a practical view of where AI adds value, where it can mislead, and why deep Db2 expertise remains essential for interpreting signals in context, managing trade-offs, and responding when the unexpected happens.
Speakers
avatar for Chad Reiber

Chad Reiber

Software Engineer, BMC Software
With a career spanning decades in IT and databases, Chad Reiber serves as a Sr. Principal Software Engineer at BMC Software. Starting as a developer at AT&T in 1983, he quickly transitioned into the database administration field, gaining extensive experience with IMS, IDMS, and Db2... Read More →
Tuesday October 27, 2026 10:20am - 11:20am EDT
Magnificent 6
  Track E, Technical Session

11:30am EDT

A7 | Real-word value: Db2 for z/OS Customer Experiences
Tuesday October 27, 2026 11:30am - 12:30pm EDT
Magnificent 3
This session will concentrate on customer experiences in Db2 13 and positioning of the next release of Db2. Where are most customers at in their Db2 13 experience, Function Levels, exploitations. What are the items customers are exploiting, utilizing and lessons learned in the endevor. Session will be a mixture of Db2 DBA and System Programmer viewpoints.
Speakers
avatar for Anthony Ciabattoni

Anthony Ciabattoni

IBM Db2 for z/OS SWAT Team Leader, IBM
Anthony Ciabattoni is an IBM Certified Executive IT Specialist and the current leader of the Db2 for z/OS SWAT Team, based out of the IBM Silicon Valley Lab. With over 32 years of hands-on experience working with Db2 for z/OS, Anthony brings deep technical expertise and a strong customer-focused... Read More →
Tuesday October 27, 2026 11:30am - 12:30pm EDT
Magnificent 3
  Track A, Technical Session

11:30am EDT

B7 | Db2 LUW Back to Basics - Backup and recovery
Tuesday October 27, 2026 11:30am - 12:30pm EDT
Magnificent 1
In this presentation we will examine in detail the backup and recovery options available to DBAs for their Db2 environments. How to tune these utilities will be discussed and results will be reviewed from numerous tests. We will see what is the “art of the possible” from using local files, COS, Storage based copies, etc. … We will take a close look at the new version enhancements and how they can improve your backup and recovery experience.
Speakers
avatar for Dale McInnis

Dale McInnis

STSM, Db2 Client Adoption Engineering, IBM
Dale McInnis is an STSM in Db2 development from the IBM Toronto Canada Lab. He has a B.Sc.(CS) from the University of New Brunswick and a Masters of Engineering(M.Eng) from the University of Toronto and is currently pursuing his PhD in computer science. Dale joined IBM in 1988 and... Read More →
Tuesday October 27, 2026 11:30am - 12:30pm EDT
Magnificent 1
  Track B, Technical Session

11:30am EDT

C7 | The Breach You Didn't See Coming: Why DAM is Your Early Warning System
Tuesday October 27, 2026 11:30am - 12:30pm EDT
Magnificent 4
Security is often treated as an afterthought—apps launched without proper controls, cloud environments spun up outside organizational standards, third-party vendors granted excessive access to sensitive data. These missteps vary in form, but they all share a common denominator: data. And for attackers, data is the only thing that truly matters.
Regardless of how strong your perimeter defenses are, once an attacker gets inside, your ability to detect and respond quickly becomes critical. That’s where Guardium Database Activity Monitoring (DAM) comes in. DAM helps organizations understand what “normal” looks like—enabling real-time detection of anomalies, suspicious behavior, and potential breaches before serious damage is done.
In this session, we’ll explore how implementing IBM Guardium can reduce risk, improve incident response, and stop data leaks before they happen. Because when everything else can be bypassed, your best defense is knowing your data patterns.
Key scenarios we’ll examine include:- Privilege escalation and misuse- High-volume data extraction- Cross-site scripting (XSS) via database inputs- OS command injection through vulnerable queries- Abuse of privileged accounts- Unauthorized access to restricted or sensitive data- Password spraying and brute-force attempts- Anomalous behavior outside of baseline operations- Change reconciliation failures (e.g., Guard App event correlation)
For each use case, we’ll analyze:- What the attack looks like in terms of raw database activity- How DAM tools can be tuned to detect these patterns- Alerting and response workflows for containment and remediation
Speakers
avatar for Tim Tait

Tim Tait

Senior Consultant, Data Protection, Pellera Technologies
Tim works for IBM Platinum Business Partner and IBM 2024 Global Digital Defense Partner of the year Pellera Technologies. He is a Senior Security Consultant within the Data Protection practice, focused on professional services for the IBM Guardium suite of products. He has over 15... Read More →
Tuesday October 27, 2026 11:30am - 12:30pm EDT
Magnificent 4
  Track C, Technical Session

11:30am EDT

D7 | Why UTS Conversion Can’t Wait Anymore
Tuesday October 27, 2026 11:30am - 12:30pm EDT
Magnificent 5
The future of Db2 for z/OS is Universal Table Spaces (UTS) with IBM signaling that the next version of Db2 will no longer support legacy structures.
At the same time, Db2 itself is evolving toward UTS, with catalog and directory objects already being prepared for conversion through future Db2 13 function levels—reinforcing that UTS is the long-term foundation of the platform.
Despite this, many environments continue to delay conversion. The result is growing data volumes, increased complexity, and higher risk when the transition eventually becomes unavoidable.
This session focuses on why UTS conversion is essential. Beyond the “why,” we will dive into the “how”—sharing real-world examples of conversion failures and lessons learned from the field.
Speakers
avatar for Rahul Bajaj

Rahul Bajaj

Software Engineer, Broadcom
Rahul is a Db2 for z/OS professional at Broadcom Inc., working as part of the Db2 tools development team. His work focuses on supporting and evolving database management solutions that power critical enterprise systems.
avatar for Sreenivas Javvaji

Sreenivas Javvaji

Software Engineer, Broadcom
Sreenivas Javvaji is an experienced mainframe professional specializing in Db2 for z/OS at Broadcom. As an R&D Engineer, he focuses on the maintenance and optimization of Broadcom Database Management Solutions, helping global enterprise customers ensure the stability and performance... Read More →
Tuesday October 27, 2026 11:30am - 12:30pm EDT
Magnificent 5
  Track D, Technical Session

2:00pm EDT

A8 | Db2 for z/OS Modernization Update & Strategy
Tuesday October 27, 2026 2:00pm - 3:00pm EDT
Magnificent 3
Db2 for z/OS continues to advance with new capabilities that simplify development, automation, and operations across the enterprise.
Join this session to explore the latest modernization updates including Db2 auto-discovery of configuration parameters, future exploitation around Configuration as Code, new APIs to support continuous integration and continuous deployment of database schema changes, and IBM Db2 Agents.
Speakers
avatar for Sueli Almeida

Sueli Almeida

IBM Certified Thought Leader, IBM Silicon Valley Lab
Sueli Almeida is an IBM Certified Thought Leader and member of Db2 for z/OS development located at the IBM Silicon Valley Lab in San Jose, California. She has extensive experience with DB2, including database administration and systems programming. She has worked on DB2 for z/OS advanced... Read More →
Tuesday October 27, 2026 2:00pm - 3:00pm EDT
Magnificent 3
  Track A, Technical Session

2:00pm EDT

D8 | Making Better Connections - A Db2 Client Primer
Tuesday October 27, 2026 2:00pm - 3:00pm EDT
Magnificent 5
Db2 can be accessed from a wide variety of client platforms and languages. But information on the best way to achieve this access is often hard to find. This presentation will examine what Db2 clients are available and then look at the best way to configure connections from these clients. As well as the basic Db2 clients it will look at language and framework specific adapters as well.
Speakers
avatar for Philip Nelson

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 →
Tuesday October 27, 2026 2:00pm - 3:00pm EDT
Magnificent 5
  Track D, Technical Session

2:00pm EDT

F8 | The Db2 Fantastic Four: How Optimization, Performance, Cost, and AI Come Together in the Modern Database Experience
Tuesday October 27, 2026 2:00pm - 3:00pm EDT
Magnificent 7
The panel frames this discussion around the aspects most critical to enterprise database operations—the “Fantastic Four”: system capacity, performance optimization, cost management, and AI-driven analysis. Panelists will share real-world experiences and practical insights on applying AI to analyze database telemetry, anticipate workload changes, optimize resource utilization, and support data-driven decision-making at scale.By bringing together perspectives from multiple organizations, this session highlights how AI-enhanced database management is evolving from reactive monitoring to intelligent, predictive operations, helping enterprises improve reliability, efficiency, and business outcomes while managing growing data demands.
Speakers
avatar for Jyotsna Chatradhi

Jyotsna Chatradhi

Sr. Manager Engineering, Broadcom
Jyotsna Chatradhi is a Senior Engineering Manager on the MSD UXUI team. She has been with Broadcom for nearly a decade, with over 20+ years of engineering experience across diverse industries. Jyotsna is an inventor with five published patents in her field and actively contributes... Read More →
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 →
Tuesday October 27, 2026 2:00pm - 3:00pm EDT
Magnificent 7
  Track F, Technical Session

4:30pm EDT

A9 | DB2 z/OS ZPARMs: Overview, Best Practices, and Recommendations
Tuesday October 27, 2026 4:30pm - 5:30pm EDT
Magnificent 3
With over 300 Db2 for z/OS subsystem parameters (zParms) constantly shifting, keeping your mainframe optimized can feel like chasing a moving target. Defaults change, deprecated parameters vanish, and critical new tuning options quietly debut - leaving many organizations running on legacy configurations that secretly drain performance and inflate costs. When was the last time you truly audited yours? Join this session to demystify the modern zParm landscape, uncover hidden configuration traps, and walk away with a battle-tested blueprint of industry best practices to supercharge your Db2 environment.
Speakers
avatar for Michal Bialecki

Michal Bialecki

Db2 technical consultant, Broadcom
Michal Bialecki is a Db2 Technical Consultant at Broadcom, bringing over 20 years of experience to the role. Prior to joining Broadcom in 2025, he spent two decades working remotely for IBM Silicon Valley Lab, where he served as a member of Db2 z/OS Development SWAT team with John... Read More →
Tuesday October 27, 2026 4:30pm - 5:30pm EDT
Magnificent 3
  Track A, 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

4:30pm EDT

F9 | Data curation as strategic advantage
Tuesday October 27, 2026 4:30pm - 5:30pm EDT
Magnificent 7
Organizations that have optimized institutional data through governance, stewardship, and quality management are AI‑ready by design. Leveraging that institutional data both internally and externally for competitive advantage opens possibilities at scale never before imagined. This session will discuss:
Tool adoption without data maturity creates risk: Weak data foundations lead to unreliable results, reduced transparency, and diminished business value.AI builds on existing data foundations: Incremental enhancements—such as data scraping, enrichment, and feature refinement—are most effective when layered on curated data stores.Efficient access to data still matters: AI tools need immediate access to data.Data curation presents as a DBA responsibility: DBAs control data curation through standard operating procedures and best practices. Decision engines still matter: AI outputs are only as effective as the decision logic, controls, and context in which they operate.AI is an evolution of data expertise, not a replacement: The role of data professionals becomes more critical, installing guardrails in automation and scalable intelligence.This session reframes AI success as the amplification of long‑standing data discipline. Attendees will gain practical insight into what they are doing today, for better or worse, that is curating data and what approaches they can apply to improve AI positioning. Best practices in database management are not a preparatory step for AI, but translate directly into sustainable AI advantage.
Speakers
avatar for Anne Hoelscher

Anne Hoelscher

Senior Director, BMC
Anne Hoelscher is a Senior Director of Product Development with many years of mainframe experience, starting in Db2 V1.2. Her early years were focused primarily on Db2 data management, architecture, and enterprise-scale data processing including consulting with new to Db2 customers... Read More →
Tuesday October 27, 2026 4:30pm - 5:30pm EDT
Magnificent 7
  Track F, 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

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
avatar for John Campbell

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

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
avatar for Colin Oakhill

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

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
avatar for Claire Connor

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

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
avatar for Ute Kleyensteuber

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

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
avatar for Anna McKee

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

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

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
avatar for Jan Prihoda

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 →
avatar for Denis Tronin

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

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
avatar for Andrew Hilden

Andrew Hilden

Chief Architect Db2 SaaS, IBM

avatar for Ashish Prasad

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

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

4:30pm EDT

D13 | Beyond the Comfort Zone: Managing, Tuning & Cross-Platform Migration of Highly Active, Mission-Critical Db2 Environments
Wednesday October 28, 2026 4:30pm - 5:30pm EDT
Magnificent 5
Managing complex Db2 LUW environments requires moving past standard practices to achieve zero-downtime availability and extreme performance. This session offers a technical blueprint for executing high-stakes cross-platform migrations from legacy AIX systems to modern Linux on Power10 and AWS/RDS cloud infrastructures. We will analyze the tuning parameters required to stabilize environments by handling 180,000 SQL statements per second, 3 TB of daily log changes, and 10,000 concurrent connections. Attendees will learn to optimize OS, storage, and network layers under strict HADR, Audits and encryption requirements. Finally, we will demonstrate how to automate database fleets using Python and leverage Db2 12.1’s native AI and Genius Hub for agentic self-healing.
Speakers
avatar for Nemi Agrawal

Nemi Agrawal

CEO, Anvaya Minds Inc
CEO/Director: Anvaya Minds
IT Specialist - Department of Homeland Security/Customs and Border Protection
Project/Program Manager: Citibank, IBM, Deutsche Bank, Deutsche Telekom\
- IBM Champion – 2023-2026
- Speaker - IBM TechXChange – 2023-2025
- Postgres Conference NYC 2023... Read More →
Wednesday October 28, 2026 4:30pm - 5:30pm EDT
Magnificent 5
  Track D, Technical Session

4:30pm EDT

E13 | Db2 HADR Performance Tuning
Wednesday October 28, 2026 4:30pm - 5:30pm EDT
Magnificent 6
This presentation will examine several key methods to configure Db2 HADR for optimal performance. We will look at the most important configuration / registry settings and discuss how they impact performance. We will also examine how to determine where the performance bottlenecks exists.
Speakers
avatar for Dale McInnis

Dale McInnis

STSM, Db2 Client Adoption Engineering, IBM
Dale McInnis is an STSM in Db2 development from the IBM Toronto Canada Lab. He has a B.Sc.(CS) from the University of New Brunswick and a Masters of Engineering(M.Eng) from the University of Toronto and is currently pursuing his PhD in computer science. Dale joined IBM in 1988 and... Read More →
Wednesday October 28, 2026 4:30pm - 5:30pm EDT
Magnificent 6
  Track E, Technical Session

4:30pm EDT

F13 | Under the Hood: A DB2 Survivor’s Logbook (2026)
Wednesday October 28, 2026 4:30pm - 5:30pm EDT
Magnificent 7
introduce knowledge learned in 2026 such as data wrapping, pacemaker, etc. Test and emphasis some experiece about old topics such as db2 auto start, db2 log path, application status with different type of interruptions,
Speakers
avatar for Kevin Hong

Kevin Hong

Senior Principle Database Architect, Global Payments
Kevin has 32 years Db2 experience, holding lot of IBM certificates for Db2 including Db2 LUW and DB2 Z/OS. Kevin has presented in IDUG many times with experiences, problems learned from day to day work.
Wednesday October 28, 2026 4:30pm - 5:30pm EDT
Magnificent 7
  Track F, Technical Session
 
Thursday, October 29
 

9:00am EDT

A14 | Why Fast Db2 for z/OS Copies Get Harder: The Impact of Newer Features on Copy Speed
Thursday October 29, 2026 9:00am - 10:00am EDT
Magnificent 3
Fast copies of Db2 for z/OS tables are increasingly difficult as newer features add structural complexity. Table versioning, partition growth and rotation, XML and LOB data, temporal and archive relationships, and deferred VSAM creation can prevent direct dataset-level copies and force slower fallback methods. This webinar explains the key challenges and what they mean for copy speed and reliability.
Speakers
avatar for Kai Stroh

Kai Stroh

Product Manager, UBS Hainer GmbH
Kai Stroh earned a Computer Science degree from the University of Darmstadt and is amainframe software developer specializing in DB2 utilities for z/OS. He designs and buildsinnovative DB2 applications and utilities often working onsite or remotely with UBS’ internationalclients... Read More →
Thursday October 29, 2026 9:00am - 10:00am EDT
Magnificent 3
  Track A, Technical Session

9:00am EDT

F14 | No-Outage Db2 Version Upgrade
Thursday October 29, 2026 9:00am - 10:00am EDT
Magnificent 7
This session should be considered because it addresses a high-value challenge for Db2 customers: performing a version upgrade with little to no application outage while preserving a reliable backout path. Based on real production experience, it covers failed upgrade scenarios, post-upgrade risk, and the operational realities of switching active workloads across versions and hardware. Rather than staying conceptual, it presents a practical, repeatable approach using Q Replication and Automatic Client Reroute (ACR), along with lessons learned on synchronization, clustered cutover behavior, and risk reduction. Attendees will leave with actionable ideas they can apply in their own environments.
This session presents a practical approach for performing a no-outage Db2 version upgrade using Q Replication and Automatic Client Reroute (ACR). It explains the drivers behind the solution, including online upgrade capabilities in competing platforms, prior failed upgrade attempts, and the need for a reliable backout strategy. The session then walks through replication setup, synchronization of an active source to the target, online cutover steps, and operational challenges in clustered environments. Attendees will learn how to move from an older Db2 version to a newer one with minimal disruption and lower upgrade risk.
Speakers
KS

Kedar Shetye

Principal Technology Engineer, Norfolk Southern

Kedar Shetye is a Principal Technology Engineer and database professional with over 20 years of experience in enterprise database technologies. His expertise includes IBM Db2 LUW, PostgreSQL, CockroachDB, and Cassandra, with a focus on high availability, disaster recovery, performance... Read More →
SB

Samer Bashir

Principal Technology Engineer, Norfolk Southern

Samer Bashir is a database professional with more than 25 years of experience across enterprise database platforms, including Sybase, IBM Db2, Oracle, Cassandra, and CockroachDB. He specializes in replication technologies such as IBM Q Replication and Change Data Capture (CDC), with... Read More →
Thursday October 29, 2026 9:00am - 10:00am EDT
Magnificent 7
  Track F, Technical Session

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

A15 | Db2 for z/OS Config-as-Code: Automated Subsystem Configuration Discovery and Provisioning
Thursday October 29, 2026 10:20am - 11:20am EDT
Magnificent 3
In this session, we will introduce a z/OS middleware configuration tool (zconfig), which is an automation tool that in a very intuitive way, will help you to discover the configuration parameters of any of your Db2 subsystems. Additionally, you will be able to provision new Db2 subsystems with a configuration like the one just discovered.
Bringing configuration-as-code and automation to Db2 for z/OS environments modernize how to perform operational processes towards your Db2 subsystem management.
Join this session to learn practical approaches to modernizing your Db2 subsystem management.
Speakers
avatar for Sueli Almeida

Sueli Almeida

IBM Certified Thought Leader, IBM Silicon Valley Lab
Sueli Almeida is an IBM Certified Thought Leader and member of Db2 for z/OS development located at the IBM Silicon Valley Lab in San Jose, California. She has extensive experience with DB2, including database administration and systems programming. She has worked on DB2 for z/OS advanced... Read More →
avatar for Shirley Xiao

Shirley Xiao

Db2 Software engineer, IBM Silicon Valley Lab
Shirley Xiao is a Software Developer working on Db2 for z/OS at IBM. She started her career at IBM working on Db2 Data Manager and now focuses on modernizing Db2 through automation, tooling, and DevOps practices. Her work includes building Db2 automation tools, integrating Db2 with... Read More →
Thursday October 29, 2026 10:20am - 11:20am EDT
Magnificent 3
  Track A, 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

10:20am EDT

F15 | Screening in a Virtualized Production Environment
Thursday October 29, 2026 10:20am - 11:20am EDT
Magnificent 7
Most IT experts know the catchphrase “Never change a running system” very well, especially once you experience that a small change can have a significant impact. Anyway, “The only constant is change” is very true as well. Even if we don’t touch an application for enhancements, we’ll face security updates, software updates, hardware updates, configuration changes and data growth.
Before moving to a new machine, applying (Db2) APARs, changing schema, or SQL, it’s common to test in a sand-box, or development system – very good, but here come the challenges:
1st There are quite a few regulations that affect reliable testing of changes and they all have one in common – DON’T USE PRODUCTION DATA!!!
2nd Without real data, or with data masked and sanitized, we’ll very likely see different results than running one and the same query in production.
This session explains how you can reliably, and resource-friendly, simulate your entire production environment, WITHOUT production data and even on a different machine.
We’ll cover prescreening changes in the following areas:

environment changes, like upgrading to a new machine, or adding more resources
application changes, like SQL queries and schema
data changes, like amount and distribution

The capabilities introduce a whole new world of "what if" opportunities and especially protect you from testing that doesn’t focus on what counts: the resulting performance in your production environment.
Speakers
UH

Ulf Heinrich

Director Solutions Delivery, SEGUS Inc
Ulf Heinrich specialized in Db2 recovery and operations, managing cost reduction and 24×7 operations. As a consultant at large customer sites, he has implemented database maintenance procedures and recovery strategies, and also experienced the pitfalls of recovery scenarios under... Read More →
Thursday October 29, 2026 10:20am - 11:20am EDT
Magnificent 7
  Track F, Technical Session

11:30am EDT

B16 | Db2 for z/OS Applications now Empowered by OpenTelemetry
Thursday October 29, 2026 11:30am - 12:30pm EDT
Magnificent 1
IBM System Z and Db2 for z/OS applications are essential to the successful operations and business workflows for major companies. Join our discussion on OpenTelemetry and its powerful impact on observability across your entire business environment. Whether you're a System Reliability Engineer or an Application Developer, this session is for you!Here's what you'll learn:

An overview of the OpenTelemetry observability framework and how it helps generate, process, and distribute telemetry data.
How Db2 for z/OS supports OpenTelemetry and how you can leverage it for your applications.
How OpenTelemetry support aligns with the broader platform, i.e. IBM System Z and Db2 for z/OS, to enhance your operations.

Don’t miss out on this opportunity to enhance your understanding and implementation of OpenTelemetry within Db2 for z/OS and its futures.
Don’t miss out on this opportunity to enhance your understanding and implementation of OpenTelemetry within Db2 for z/OS and its futures.
Speakers
avatar for Sueli Almeida

Sueli Almeida

IBM Certified Thought Leader, IBM Silicon Valley Lab
Sueli Almeida is an IBM Certified Thought Leader and member of Db2 for z/OS development located at the IBM Silicon Valley Lab in San Jose, California. She has extensive experience with DB2, including database administration and systems programming. She has worked on DB2 for z/OS advanced... Read More →
avatar for Derek Tempongko

Derek Tempongko

Back-End Developer, IBM Silicon Valley Lab
Derek Tempongko is a Senior Software Engineer on the Db2 for z/OS distributed development team at the IBM Silicon Valley Laboratory. With over 20 years of experience in Distributed Data Facility (DDF), presented at previous IDUG events, authored a Redpaper on TLS/SSL which has been... Read More →
Thursday October 29, 2026 11:30am - 12:30pm EDT
Magnificent 1
  Track B, Technical Session

11:30am EDT

F16 | Db2 12.1: Advances in Operational Resiliency for Mission-Critical Workloads
Thursday October 29, 2026 11:30am - 12:30pm EDT
Magnificent 7
This session explores the latest advancements in Db2 LUW designed to ensure continuous reliability, high availability, and disaster recovery for enterprise databases. Attendees will gain insight into new features introduced since Db2 v12.1, including integrated automated HA solutions with Pacemaker, online upgrades and maintenance with minimal disruption, and seamless backup and recovery enhancements. The presentation covers the architecture and operational principles of Db2 pureScale, demonstrating how it delivers near-linear scalability, robust transactional integrity, and rapid failover across cloud and on-prem environments. Real-world testing scenarios and enterprise-grade validation processes are highlighted to showcase how Db2 achieves platinum-level resiliency. Whether you manage mission-critical workloads or architect resilient database solutions, this session provides actionable strategies and technical guidance to maximize uptime, streamline maintenance, and future-proof your Db2 deployments

Speakers
avatar for Christian Garcia-Arellano

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

2:00pm EDT

B201 | From Db2 First Responder to Emergency Technician - The problem determination master workshop
Thursday October 29, 2026 2:00pm - 3:30pm EDT
Magnificent 1
Db2 delivers a wide range of tools for problem determination. Those tools range from the new Log Analysis Capability in IBM Db2 Genius Hub to classical tools that can and should be used for deeper analysis. As the Db2 community constantly welcomes new database administrators and application developers, an effecient tooling and its use is required for those new community mambers. The session will share tools and best practices for the first occurrence data capture (FODC) tools available for DBAs and developers. This session will cover the first steps in the process of problem determination and problem source identification (PD/PSI). It provides hands-on and practical examples for the strategy and process to encircle and find problems by asking the right questions.
Speakers
avatar for Thomas Rech

Thomas Rech

Architect Db2 SAP Dev. & Client Adoption Engineering, IBM

Sponsors
I
Thursday October 29, 2026 2:00pm - 3:30pm EDT
Magnificent 1
  Track B, Workshop

2:00pm EDT

C201 | Db2 for z/OS modernized: Visual Studio Code deep dive
Thursday October 29, 2026 2:00pm - 3:30pm EDT
Magnificent 4
4 hours Hands-on-lab workshop (BYOD - Bring Your Own Device)
Transition from legacy "green screen" interfaces to a modern, high-performance environment using Visual Studio Code. This workshop provides a deep dive into Zowe Explorer and the Code4z extension pack, streamlining both system and database management. You will learn to handle z/OS core tasks - including dataset and USS file operations, job submission, and CLI terminal commands - alongside essential Db2 DBA tasks like schema management and SQL execution. We will also cover best practices for managing VS Code setups and profiles to ensure your workflow is optimized for daily enterprise use. Master these modern tools to simplify and accelerate your Db2 operations.
Speakers
avatar for Jim Endler

Jim Endler

Technical Consultant, Broadcom
Jim Endler is a Principal Technical Consultant at Broadcom who focuses on helping customers manage and optimize their Db2 for z/OS environments. He works closely with them to improve database performance and modernize operations through automation, ensuring mainframe systems remain... Read More →
avatar for Toine Michielse

Toine Michielse

Client Services Management | Mainframe Software Division | Broadcom, Broadcom
Toine Michielse believes the future of the mainframe depends on building bridges – between platforms, between generations, and between past and present ways of working.
A four-time IBM Champion and long-time advocate for modernization, Toine has reimagined what it means to be a Db2 for z/OS administrator in the era of DevOps and hybrid cloud. His message resounds: to move forward, we don’t need to discard the platform’s strengths; we need to... Read More →
Sponsors
B
Thursday October 29, 2026 2:00pm - 3:30pm EDT
Magnificent 4
  Track C, Hands-On Lab

3:45pm EDT

B202 | Understanding ADMIN_MOVE_TABLE: A Comprehensive Workshop on Best Practices and Pitfalls
Thursday October 29, 2026 3:45pm - 5:15pm EDT
Magnificent 1
Since 2012, the ADMIN_MOVE_TABLE stored procedure has stood for versatility. Whether you're facing extraordinary challenges or handling everyday tasks, ADMIN_MOVE_TABLE has you covered as a DBA. ADMIN_MOVE_TABLE, or AMT for short, has been continually expanded and new application areas have been added. Today, it's important to understand the architecture and design principles of AMT to understand the best use cases and avoid pitfalls. This workshop will guide you through the AMT functionality, starting with the initial intended use cases, and the most used scenarios. But even more importantly, the instructors will discuss and show pitfalls and will guide trough the problem analysis process for AMT.
Speakers
avatar for Thomas Rech

Thomas Rech

Architect Db2 SAP Dev. & Client Adoption Engineering, IBM

Sponsors
I
Thursday October 29, 2026 3:45pm - 5:15pm EDT
Magnificent 1
  Track B, Workshop

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

D202 | Db2 z/OS Housekeeping Best Practices
Thursday October 29, 2026 3:45pm - 5:15pm EDT
Magnificent 5
This 4 hours workshop - knowledge transfer session will be conducted by following presenters: Toine Michielse, Michal Bialecki, Emil Kotrc, Denis Tronin
In the world of Db2 for z/OS, "set it and forget it" is a recipe for performance degradation and wasted storage. As data volumes explode and batch windows shrink, traditional housekeeping—REORG, RUNSTATS, and IMAGE COPY—must evolve from manual chores into a streamlined, automated strategy.
This deep-dive workshop provides a comprehensive blueprint for modern Db2 maintenance. We will move past the basics to explore how to balance object availability with optimal performance. Attendees will learn how to leverage the latest utility enhancements to reduce CPU consumption, manage multi-terabyte objects, and ensure that the optimizer always has the "ground truth" through intelligent statistics collection.
Speakers
avatar for Toine Michielse

Toine Michielse

Client Services Management | Mainframe Software Division | Broadcom, Broadcom
Toine Michielse believes the future of the mainframe depends on building bridges – between platforms, between generations, and between past and present ways of working.
A four-time IBM Champion and long-time advocate for modernization, Toine has reimagined what it means to be a Db2 for z/OS administrator in the era of DevOps and hybrid cloud. His message resounds: to move forward, we don’t need to discard the platform’s strengths; we need to... Read More →
avatar for Denis Tronin

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 →
Sponsors
B
Thursday October 29, 2026 3:45pm - 5:15pm EDT
Magnificent 5
  Track D, Workshop

3:45pm EDT

E202 | Unlock the Power of Managed Data: The Amazon RDS for Db2 Immersion Day Hands-on Experience
Thursday October 29, 2026 3:45pm - 5:15pm EDT
Magnificent 6
Are you ready to move beyond managing infrastructure and start innovating with your data? This hands-on workshop provides a deep dive into migrating and modernizing IBM Db2 workloads using Amazon RDS for Db2. Participants will gain practical experience in executing seamless migrations from platforms like Linux, AIX, or z/OS while ensuring high availability and optimized performance.Beyond the migration, you will explore how to unlock the value of your data by integrating AWS AI/ML services. You'll learn to build intelligent applications using Amazon Bedrock powered by your live RDS for Db2 data. By the end of this session, you will have a clear blueprint for transforming your legacy databases into a modern, AI-ready data foundation.
Speakers
avatar for Andrew Hilden

Andrew Hilden

Chief Architect Db2 SaaS, IBM

avatar for Ashish Prasad

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 →
Sponsors
A
Thursday October 29, 2026 3:45pm - 5:15pm EDT
Magnificent 6
  Track E, 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