Loading…
Type: Track F clear filter
Monday, October 26
 

11:30am EDT

F2 | Introduction to SQL-PL
Monday October 26, 2026 11:30am - 12:30pm EDT
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

2:00pm EDT

F3 | Debugging SQL PL - Without a Debugger
Monday October 26, 2026 2:00pm - 3:00pm EDT
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

3:20pm EDT

F4 | SQL Oldies but Goodies and the Power of the SQL Rewrite
Monday October 26, 2026 3:20pm - 4:20pm EDT
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

4:30pm EDT

F5 | You should concentrate (your literals) - Dynamic SQL performance tips
Monday October 26, 2026 4:30pm - 5:30pm EDT
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
 
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
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

11:30am EDT

F7 | Bob meets Db2 for z/OS
Tuesday October 27, 2026 11:30am - 12:30pm EDT
After completing an assessment of IBM’s Bob, using Db2 for z/OS use cases, I was amazed and disappointed. This introductory session summarizes key items found during the assessment. I’ll demonstrate a Db2 for z/OS client and a System Profiles GUI created, both without writing a single line of code.
Speakers
PB

Paul Bartak

Distinguished Engineer, Rocket Software
Paul Bartak has been working with Db2 for z/OS since V1.2 as a customer and as a solution provider across industries. As a Distinguished Engineer, with Rocket Software, Paul is focused on the tools used to maximize z/OS platform value, with an emphasis in database administration... Read More →
Tuesday October 27, 2026 11:30am - 12:30pm EDT
Magnificent 7

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

4:30pm EDT

F9 | Data curation as strategic advantage
Tuesday October 27, 2026 4:30pm - 5:30pm EDT
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
 
Wednesday, October 28
 

10:20am EDT

F10 | AI as a partner for the Db2 Professional
Wednesday October 28, 2026 10:20am - 11:20am EDT
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

11:30am EDT

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

Jørn Thyssen

Senior Technical Staff Member, Rocket Software
Jørn Thyssen is a Senior Technical Staff Member at Rocket Software, working with mainframe and Db2 tools in customer modernization and performance projects. He has extensive experience with IBM Z and Db2 for z/OS, and collaborates closely with development teams on initiatives involving... Read More →
Wednesday October 28, 2026 11:30am - 12:30pm EDT
Magnificent 7

2:00pm EDT

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

Mohan Saraswatipura

Senior Consultant, DBA Automation
Mohankumar Saraswatipura is an IBM Gold Consultant specializing in database solutions. His background demonstrates versatile expertise in database architecture and administration, particularly with Db2 environments.
Wednesday October 28, 2026 2:00pm - 3:00pm EDT
Magnificent 7

4:30pm EDT

F13 | Under the Hood: A DB2 Survivor’s Logbook (2026)
Wednesday October 28, 2026 4:30pm - 5:30pm EDT
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
 
Thursday, October 29
 

TBA

FORMERLY F16 | Accelerating DB2 Development with AI: A Live Demo of Bob's Comprehensive Workflow Automation
Thursday October 29, 2026 TBA
Discover how AI coding assistants transform DB2 development. This live demonstration showcases Bob, an AI-powered tool that automates schema design, generates optimized SQL queries, debugs complex issues, and tunes performance—all through natural language. See real-time examples of migration planning, query optimization, and troubleshooting that reduce development time by 60%. Learn practical integration strategies for your DB2 workflows.
Speakers
HS

Harmeet Singh

ATL, IBM
Harmeet Singh Principal Account Technical Leader for the US. Federal Intelligence Community serves as Trusted Partner across Federal Intelligence Community to help agencies address the complex hybrid cloud and cognitive AI digital transformation needs. Provide IBM Cross Brand Solution... Read More →
Thursday October 29, 2026 TBA
Magnificent 7

9:00am EDT

F14 | No-Outage Db2 Version Upgrade
Thursday October 29, 2026 9:00am - 10:00am EDT
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

10:20am EDT

F15 | Screening in a Virtualized Production Environment
Thursday October 29, 2026 10:20am - 11:20am EDT
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

11:30am EDT

E16 | Db2 Always On Architecture
Thursday October 29, 2026 11:30am - 12:30pm EDT
In this presentation we will discuss the resiliency offerings for DB2 and how they can be combined to provide an Always On architecture.  What are the process changes required, how to I determine what needs to be done and what can I do today. The IBM Always On architecture allows you to run your client facings systems 24 by 7 by 365 with zero downtime.

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

11:30am EDT

F16 | Db2 12.1: Advances in Operational Resiliency for Mission-Critical Workloads
Thursday October 29, 2026 11:30am - 12:30pm EDT
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

2:00pm EDT

F201 | Optim High Performance Unload for Db2 for LUW: Accelerating Data Access and Modern Workloads
Thursday October 29, 2026 2:00pm - 3:30pm EDT
Efficient data extraction is critical for analytics, migrations, and modern application integration. Optim High Performance Unload (HPU) provides a powerful, flexible, and lightning-fast way to unload Db2 data without impacting production workloads. This session will explore how HPU can be used for faster unloading and migrating data by using direct access methods to deliver unmatched performance compared to traditional unload utilities. In addition, we will demonstrate how HPU can recover data directly from backup images in the event of table loss, ensuring business continuity and minimizing downtime. Attendees will learn best practices for optimizing unload tasks, and handling large-scale migrations to cloud or hybrid environments. Real-world case studies will highlight performance gains, reduced disk space consumption, and simplified operations. Whether you are a DBA, or architect, this session will equip you with practical strategies to maximize the value of HPU in your enterprise.
Speakers
VA

Vincent Arrat

Product Manager, Infotel
Vincent Arrat has been developing and supporting Optim High Performance Unload (HPU) for more than 25 years, bringing unmatched expertise in the product’s design and capabilities. With his deep knowledge of HPU, Vincent helps organizations define the best strategies to achieve their... Read More →
avatar for Cintia Ogura

Cintia Ogura

Technical Support Leader for Db2 Tooling Products, IBM Corporation
Supporting Db2 Tools Products for more than 29 years, Cintia brings deep expertise in database administration and enterprise data management, with a passion for helping DBAs and architects maximize the value of Db2 tools by sharing real-world experiences. In recent years, she has... Read More →
Sponsors
Thursday October 29, 2026 2:00pm - 3:30pm EDT
Magnificent 7

3:45pm EDT

F202 | Bridging Structured and Unstructured Data: Hybrid AI Queries with Db2
Thursday October 29, 2026 3:45pm - 5:15pm EDT
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
Thursday October 29, 2026 3:45pm - 5:15pm EDT
Magnificent 7
 
Share Modal

Share this link via

Or copy link

Filter sessions
Apply filters to sessions.