IDUG EMEA 2026: Full Schedule

Are you running maintenance because it’s Sunday, or because the data actually needs it? With shrinking windows and massive data growth, "business as usual" is no longer an option. This session explores how Broadcom Db2 utilities provide the precision and confidence needed to manage modern environments. We will discuss establishing data-driven housekeeping practices, leveraging recovery toolkits to validate resilience without production impact, and optimizing high-speed data movement to support DevOps and rapid testing. Learn to transform your batch utilities from a routine expense into a high-performance engine.

Speakers

Denis Tronin

Product Manager, Broadcom Mainframe Software

Denis Tronin is an experienced IT professional and product manager, skilled in mainframe technologies (Db2 for z/OS, system performance, workload automation), API management (Zowe API Mediation Layer), and DevOps. He is an IBM Champion and a frequent speaker at major industry con... Read More →

Tuesday September 29, 2026 10:20am - 11:20am BST
Infante

Track A, Technical Session

Topic Best Practices, Database Resiliency, Data Movement and Integration, Utilities
Audience All
Platform z/OS

10:20am BST

B6 From Complexity to Operational Intelligence: Modernizing Database Administration with AI on IBM Z

Tuesday September 29, 2026 10:20am - 11:20am BST

Arrabida

Db2 and IMS database administrators on IBM Z are increasingly expected to support modern, AI‑enabled business initiatives while continuing to manage complex, mission‑critical transactional environments. Traditional operational workflows—often manual and reliant on deep individual expertise—can limit consistency and scalability as systems evolve.
This session introduces IBM Z Database Assistant, which brings agent‑assisted intelligence into Db2 and IMS administration. By combining DBA‑centric AI agents with context‑driven dashboards, the Database Assistant helps DBAs better understand database behavior, evaluate operational impact, and take informed actions—reducing the need for manual interpretation across multiple tools.
Attendees will see how natural language interaction can simplify common DBA tasks, how intelligent SQL tuning can improve transactional workload efficiency, and how AI agents can assist with faster problem diagnosis across Db2 and IMS environments.

Speakers

Akiko Hoshikawa

Distinguished Engineer - Db2 for z/OS and Db2 AI for z/OS, IBM

Brian Tsao

System Architekt, IBM

Architect of IBM Z Database Assistant and Technical Lead for IBM Db2 for z/OS Agent. Experienced in enterprise mainframe systems, modern cloud-native tooling, and emerging agentic workflows. Passionate about bridging Z systems with modernization, driving innovation that brings legacy... Read More →

Tuesday September 29, 2026 10:20am - 11:20am BST
Arrabida

Track B, Technical Session

Topic AI GenAI and Machine Learning, Modernization in Operations
Audience All
Platform AI / ML

10:20am BST

C6 Zero Downtime Dreams: A Newcomer’s Guide to Db2 Resilience

Tuesday September 29, 2026 10:20am - 11:20am BST

Porto

High availability and disaster recovery capabilities are essential for safeguarding mission-critical Db2 environments. Yet for many beginners, the variety of available technologies including backup and recovery strategies, clustering solutions, replication tools, and multi-cloud architecture can feel overwhelming. This session provides a clear, approachable introduction to the full Db2 High availability and disaster recovery landscape, based on real-world experiences. We will walk through the fundamentals of Db2 backup and recovery, explain how Db2 HADR works and when it’s the right choice, and demystify clustering frameworks such as Pacemaker and PowerHA. You will also learn where pureScale fits into HA planning, how Q Replication and CDC support active-active or near real-time availability, and how modern cloud and multi-cloud deployment models are reshaping resiliency design. Whether you’re new to Db2 or looking to strengthen your foundational knowledge, this session will give you t

Speakers

Iqbal Goralwalla

Principal Sales Engineer, Triton Consulting Ltd

An IBM Gold Consultant and an IBM Champion for Data Management, Iqbal Goralwalla has over 20 years of experience in all aspects of relational databases on the LUW platform. Iqbal is also a member of IBM’s Technical Advisory Board. Iqbal is a highly experienced Data Management specialist... Read More →

Damir Wilder

Db2 SME and Data Architect, Triton Consulting Ltd

I am a Senior Consultant at Triton Consulting, a UK based company that specializes in Hybrid Data Management, Digital Transformation and DB2 database and Information Management services for the z/OS and Midrange.
My area of expertise is the Midrange platform (predominantly Linux and AIX, both on-prem and Cloud).I have started working as a DB2 DBA in year 2000 on the DB2 version 5.0 and have working experience from that version up to the latest v12.1.I am a certified DB2 v10/v11.1/v11.5 LUW... Read More →

Tuesday September 29, 2026 10:20am - 11:20am BST
Porto

Track C, Technical Session

Topic Automation, Back to Basics, Database Resiliency
Audience Beginner
Platform LUW

10:20am BST

D6 Permitting, masking and trusting, a deep dive into 3 new Db2 12.1 security features

Tuesday September 29, 2026 10:20am - 11:20am BST

Maria

This session is a deep dive into 3 new Db2 12.1 security features, Reduce file permissions, RCAC mask at read enhancements, and defining a Trusted Context using the new trust procedure and client callbacks. This will be a face paced session offering practical details on how to make use of these new features in more depth than a what's new session can cover. Reduced file permissions address the common concern of everyone having access to the db2diag.log (and others). Mask at read offers an alternative masking behaviour with fundamental changes to SQL behaviour. And Trust Procedures allow custom definitions of trust for determining a trusted connection.

Speakers

Greg Stager

Senior Software Engineer, IBM

Greg Stager is the security architect for Db2 LUW at the IBM Toronto Lab. Greg has been a member of the Db2 security development team since 2000, where he has worked on all aspects of security within Db2, including authentication, authorization, auditing and encryption.

Tuesday September 29, 2026 10:20am - 11:20am BST
Maria

Track D, Technical Session

Topic Best Practices, Latest and Features LUW, Modernization in Operations, Security and Compliance
Audience Intermediate
Platform LUW

10:20am BST

E6 High Availability Q-replication in a heterogeneous Db2 HA environment

Tuesday September 29, 2026 10:20am - 11:20am BST

Luis

When using Q-replication in evironments with different Db2 HA configuraions like HADR and pureScale and even single server Db2 installations or Db2 z/Os all together, configuration of Q-replication can become quite complex, especially on pureScale when trying to integrate the capture and apply programs into the resource model.
In this presentraion we will go through a different approach and build a seperate HA cluster for the Q-replication environment. This approach simplifies the setup of Q-replicatation and makes the target and source Db2 environment trasnparent to the replication environment, and it works with all possible Db2 setups.
And the best part, if you use Q-replication and Db2 LUW, you already have all the needed parts for this setup.

Speakers

Sven Heidorn

Senior Sales Engineer, CSN

I have 35 years of experience with Db2 starting with Db2 on z/OS but have spent the last 25 years working with Db2 LUW as a DBA and system programer. Primary expertise is with HA environment e.g. pureScale GDPC. I also have extensive experience with both SQL- and Q-replication.

Tuesday September 29, 2026 10:20am - 11:20am BST
Luis

Track E, Technical Session

Topic Database Resiliency, Data Movement and Integration, User Stories
Audience Intermediate
Platform LUW

10:20am BST

F6 Scripting Db2 for z/OS

Tuesday September 29, 2026 10:20am - 11:20am BST

Miragaia

Integrating Db2 for z/OS with non-mainframe processes is easy if you learn how to use Db2 with scripting languages, particularly exploiting Db2 client capabilities and ZOWE. This presentation explains how to do this, and shows some classic use cases in database administration and DevOps.

Speakers

Philip Nelson

Senior Database Software Engineer, Lloyds Banking Group / ScotDB Limited

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

Tuesday September 29, 2026 10:20am - 11:20am BST
Miragaia

Track F, Technical Session

Topic AppDev, Automation, Modernization in Development, Modernization in Operations
Audience All
Platform z/OS

10:30am BST

IDUG Db2 for LUW Essentials

Tuesday September 29, 2026 10:30am - 5:30pm BST

Glass 1

Speakers

Davor Rodnis

IDUG Db2 for LUW Essentials Instructor

Davor is an expert trainer and consultant with 30+ years’ experience in Db2. He specialized in providing Db2 and other training services for IBM customers in over 25 countries according to global standards. He has taught over 300 courses on IBM software products as an IBM Authorized... Read More →

Tuesday September 29, 2026 10:30am - 5:30pm BST
Glass 1

Essentials, Essentials

Audience Beginner

10:30am BST

IDUG Db2 for z/OS Essentials

Tuesday September 29, 2026 10:30am - 5:30pm BST

Noble

Speakers

Dougie Lawson

IDUG Db2 for z/OS Essentials Instructor

Tuesday September 29, 2026 10:30am - 5:30pm BST
Noble

Essentials, Essentials

Audience Beginner

11:30am BST

A7 Db2 for z/OS Utilities Best Practices

Tuesday September 29, 2026 11:30am - 12:30pm BST

Infante

As IBM continues to deliver new utility enhancements, it's important to take a step back and review what options really matter and how to get the best performance and availability from utility executions. This session will explain general recommendations for utility performance as well as look at specific utilities to see how they can be optimised to make a real difference to performance, application availability and usability.

Speakers

Haakon Roberts

DE, CTO, IBM

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

Tuesday September 29, 2026 11:30am - 12:30pm BST
Infante

Track A, Technical Session

Topic Best Practices
Audience All
Platform z/OS

11:30am BST

B7 Revisiting Query Parallelism: Targeted Use of zIIP Processors for Db2 Queries

Tuesday September 29, 2026 11:30am - 12:30pm BST

Arrabida

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 that will illustrate these principles in action, showcasing tangible improvements. Additionally, we will discuss how ChatGPT can assist in the query tuning processs. Join me to rediscover the power of parallelism and leverage zIIP processors to their fullest potential.

Speakers

Thomas Baumann

Data Evangelist, Swiss Mobiliar

As Data Evangelist at Swiss Mobiliar in Bern, Switzerland, Thomas is dedicated to optimizing databases and managing database risks. When he's not in the office, he can be found sharing his expertise on database optimization and risk management at various speaking engagements. Thomas... Read More →

Tuesday September 29, 2026 11:30am - 12:30pm BST
Arrabida

Track B, Technical Session

Topic AI GenAI and Machine Learning, Performance and Monitoring, User Stories, Working with SQL
Audience All
Platform z/OS

11:30am BST

C7 Db2 AI Query Optimizer: Smarter Plans, Less Tuning

Tuesday September 29, 2026 11:30am - 12:30pm BST

Porto

Since Db2 12.1, the Db2 AI Query Optimizer has been improving the quality of your query access plans through improved cardinality estimates. This was super-charged in 12.1 mod3 when it was enhanced to support pair-wise join cardinality estimates. Participants will learn how this technology reduces tuning efforts so you can confidently use it in production. You may also get a glimpse into what's in store for the future.

Speakers

Liam Finnie

Senior Software Developer, IBM

Liam joined IBM in 1999 as a software developer, and since then has been designing and implementing various features in Db2 LUW. Most recently, Liam has been leading the Machine Learning Infrastructure area for the Db2 AI Query Optimizer.

Tuesday September 29, 2026 11:30am - 12:30pm BST
Porto

Track C, Technical Session

Topic AI GenAI and Machine Learning, Latest and Features LUW, Modernization in Development
Audience Intermediate
Platform LUW

11:30am BST

D7 Near zero downtime migration to Db2 12.1

Tuesday September 29, 2026 11:30am - 12:30pm BST

Maria

When upgrading to Db2 12.1 additional activities like OS upgrade or cluster technique change might occur. In addition, test migrations should be possible with no or minimal impact on a productive system. The presentation shows, how Db2 can be migrated to 12.1 including OS upgrade scenarios and cluster technology changes, build on pure Db2 functionality. It describes a near zero downtime solution. With it's repeatability, the solution can easily be used for pre-migration testing.

Speakers

Christiane Beyer

Senior Solution Engineer, Arvato Systems GmbH

Experienced IT professional with over 25 years experience in database administration on LUW.
Specialized in IBM Db2 on Linux over 10 years. Supporting High Availability Systems in health care & financial sector, which are based on IBM Db2 HADR TSAMP & Pacemaker Cluster.

Tuesday September 29, 2026 11:30am - 12:30pm BST
Maria

Track D, Technical Session

Topic Best Practices
Audience All
Platform LUW

11:30am BST

E7 Why this query runs so slow? Step-by-step SQL troubleshooting with MON_GET interfaces and event monitors

Tuesday September 29, 2026 11:30am - 12:30pm BST

Luis

It is the classic DBA dilemma: the statistics are current, the access plan looks "clean" at first glance, yet the application is dragging. When the low-hanging fruit has been picked, how do you move from intuition to evidence-based troubleshooting?
This session follows a real-world "detective story" of a slow-running SQL statement originating from a Java (JDBC) application. We will move beyond basic EXPLAIN facility outputs to uncover the hidden bottlenecks that standard tools often miss. Using a step-by-step methodology, we will demonstrate how to:
- Capture the invisible: Isolate specific statements from the Package Cache and extract elusive parameter marker values.
- Leverage MON_GET: Use light-weight monitoring interfaces to identify where time is actually being spent (CPU vs. Wait times).
- Analyze the "Why": Utilize Activity Event Monitors and Section Actuals to compare estimated vs. actual cardinalities within a live execution.
- Apply Surgical Fixes: Explore advanced remediatio

Speakers

Kamil Kuduk

Solution Consultant, IBM Poland

Working for IBM Db2 in support role for over 10 years. Last few years in the Advanced Problem Determination team, specializing in performance problems and operating system troubleshooting.

Tuesday September 29, 2026 11:30am - 12:30pm BST
Luis

Track E, Technical Session

Audience Intermediate
Platform LUW

11:30am BST

F7 The Anatomy of Universal Tablespaces

Tuesday September 29, 2026 11:30am - 12:30pm BST

Miragaia

Universal Tablespaces (UTS) have been the strategic tablespace types for Db2 for z/OS since Version 9, effectively rendering legacy tablespaces obsolete. But what truly lies beneath the surface? Why has IBM designated UTS as the future of data storage?
In this session, we will place the Universal Tablespace on the operating table for a surgical comparison against legacy objects. We will examine the internal anatomy of Partition-by-Growth (PBG) and Partition-by-Range (PBR) tablespaces. By dissecting the underlying page structures, space map management, and segmentation logic, we will reveal exactly what makes UTS special.
Join us for a deep dive into the bits and bytes of Db2 storage to understand why the transition to UTS is not just a recommendation, but a necessity for modern database performance and management.

Speakers

Emil Kotrc

Principal Software Architect, Broadcom

Emil is a software architect at Broadcom Mainframe Software, he holds a Ph.D. in Mathematical Engineering, is a member of the IDUG Content Committee, and an IBM Champion since 2015.

Tuesday September 29, 2026 11:30am - 12:30pm BST
Miragaia

Track F, Technical Session

Topic Back to Basics, Database Resiliency
Audience Intermediate
Platform z/OS

12:30pm BST

Lunch

Tuesday September 29, 2026 12:30pm - 2:00pm BST

Archive

Tuesday September 29, 2026 12:30pm - 2:00pm BST
Archive

IDUG, Lunch

Audience All

2:00pm BST

A8 BMC AMI Db2 Utilities - What's New

Tuesday September 29, 2026 2:00pm - 3:00pm BST

Infante

Quickly and Easily solve your most demanding Db2 utility challenges using the latest capabilites available in the BMC AMI Db2 utilities. This presentation covers the latest enhnacements in the BMC utilities for Db2 zOS. Come learn how BMC customers solve their hardest operational problems every day using the Db2 utilities from BMC. Gain deep insights on the advanced performance, useability and automation features available today in the BMC Db2 Utilities that set us apart from the competion.

Speakers

Michael Cotignola

BMC Db2 Solution Engineer, BMC Software

Michael Cotignola is a Principal Software Consultant supporting BMC's DB2 Mainframe Solutions. In this role, he helps his clients maximize the value they receive from BMC's DB2 products. Michael has worked in IT since 1975 in numerous IT disciplines, including operations, application... Read More →

Tuesday September 29, 2026 2:00pm - 3:00pm BST
Infante

Track A, Technical Session

Topic Utilities
Audience All
Platform z/OS

2:00pm BST

B8 Get Cozy with WLM: Why Every Db2 DBA Needs to Understand Workload Management

Tuesday September 29, 2026 2:00pm - 3:00pm BST

Arrabida

Many Db2 DBAs treat the z/OS Workload Manager (WLM) as "the system programmer’s problem," but WLM is actually the engine that determines if your SQL succeeds or fails. In this session, we will demystify WLM from a DBA’s perspective. We’ll cover the basics: defining service classes, importance, and goals. You will learn how WLM distinguishes between "local" work (like batch) and "remote" SQL (using enclaves), and why this matters for your daily performance monitoring. We’ll wrap up with simple best practices and a look at how to spot WLM issues before they become outages. Join this session to learn how to speak the language of WLM and ensure your Db2 workload gets the priority it deserves.

Speakers

Denis Tronin

Product Manager, Broadcom Mainframe Software

Tuesday September 29, 2026 2:00pm - 3:00pm BST
Arrabida

Track B, Technical Session

Topic Best Practices, Performance and Monitoring
Audience All
Platform z/OS

2:00pm BST

C8 Db2 Meets Generative AI: Agentic AI, Vector Search, and Beyond.

Tuesday September 29, 2026 2:00pm - 3:00pm BST

Porto

This session will bring you up to speed on exciting enhancements and capabilities we are bringing to Db2 for the Generative AI era. We’ll talk about our overall AI strategy for Db2 and how we are both leveraging Generative AI as well as supporting the emerging frontier of Generative AI applications. We’ll then dive into specifics including our AI Vector Search capabilities, AI integrated LLM capabilities, and our Agentic AI powered tooling including the new Genius Hub.

Speakers

Jillian Quiller

Senior Software Engineer, Db2 Development, IBM

Growth Product Manager focused on accelerating adoption and impact across IBM’s Db2 portfolio. I combine analytics, design thinking, and experimentation to help enterprise customers unlock value faster — turning insights into measurable, scalable growth.

Mike Springgay

STSM Db2 Architect, IBM

Mike Springgay is the Db2 Architect. Prior to that he was responsible for architecting extensions to Db2’s Warehouse capabilities, SQL compatibility features, routine infrastructure and client server connectivity.

Tuesday September 29, 2026 2:00pm - 3:00pm BST
Porto

Track C, Technical Session

Topic AI GenAI and Machine Learning, Latest and Features LUW, Modernization in Development, Modernization in Operations, Performance and Monitoring
Audience All
Platform LUW

2:00pm BST

D8 SQL in Action: One Statement to Rule Them All - MERGE and integrated SQL operations

Tuesday September 29, 2026 2:00pm - 3:00pm BST

Maria

If multiple statements can be combined into a single one it will be more efficient.
In this session we will explore multiple options to combine different SQL statements. Have you ever used the FINAL TABLE clause or selected the data you just deleted? Besides this the main focus is on the MERGE stamement which is probably the most powerful SQL operation which offers a lot of processing options and can even be used in ETL architectures and with temporal tables. Practical use case will be shown and explained.

Speakers

Michael Tiefenbacher

Distinguished Engineer, Broadcom

Michael Tiefenbacher holds a Master of Science degree from the Munich Institute of Technology. He began his career as a Db2 trainer and was instrumental in introducing IBM’s Business Intelligence course curriculum in Germany.
With more than 25 years of experience in projects an... Read More →

Tuesday September 29, 2026 2:00pm - 3:00pm BST
Maria

Track D, Technical Session

Topic AppDev, Data Movement and Integration, Working with SQL
Audience Intermediate
Platform LUW

2:00pm BST

E8 "No pain - no gain - story of optimizing DELETE purge processing"

Tuesday September 29, 2026 2:00pm - 3:00pm BST

Luis

A critical Db2 for z/OS purge batch is repeatedly abending after hitting CPU limits—without deleting a single row. What followed was a six-month troubleshooting marathon. With the batch spending over 80% of its time in I/O wait and racking up 500 million GETPAGEs on a 2-million-row table, standard tuning simply wasn't enough.This session dives into the gritty reality of complex performance tuning: the dead ends, the false starts, and the eventual breakthroughs. We will walk through the entire investigation—from utilizing monitoring tools to experimenting with UTS conversions and dedicated buffer pools. Finally, we’ll reveal how rethinking our DELETE index strategy, host variables, and leveraging ON DELETE CASCADE NOT ENFORCED transformed a CPU-crushing failure into a consistent, 20-minute purge process. Attendees will leave with a practical, battle-tested methodology for rescuing failing batch processes.

Speakers

Tereza Binarova

Technical Lead zProducts, Kyndryl

Tereza Binarova is a Db2 for z/OS Database Administrator at Kyndryl, where she has worked since 2021. She specializes in performance optimization, concurrency tuning, and complex production problem resolution in enterprise mainframe environments. Her responsibilities include maintenance... Read More →

Tuesday September 29, 2026 2:00pm - 3:00pm BST
Luis

Track E, Technical Session

Topic Back to Basics, Best Practices, User Stories
Audience Intermediate
Platform z/OS

2:00pm BST

F8 Ready Player One? Db2 vNext Migration (Made Easy)

Tuesday September 29, 2026 2:00pm - 3:00pm BST

Miragaia

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

Speakers

Roy Boxwell

Senior Software Architect, Software Engineering GmbH

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

Tuesday September 29, 2026 2:00pm - 3:00pm BST
Miragaia

Track F, Technical Session

Topic Latest and Features z/OS, Security and Compliance, Working with SQL
Audience Intermediate
Platform z/OS

3:00pm BST

Coffee Break

Tuesday September 29, 2026 3:00pm - 3:20pm BST

Archive

Tuesday September 29, 2026 3:00pm - 3:20pm BST
Archive

IDUG, Break

Audience All

3:20pm BST

A101 Your GenAI Journey Takes CenterStage

Tuesday September 29, 2026 3:20pm - 4:20pm BST

Infante

Sponsors

Broadcom

Tuesday September 29, 2026 3:20pm - 4:20pm BST
Infante

PSP, PSP

Topic PSP
Audience All
Platform z/OS
Company Broadcom

3:20pm BST

B101 Coming Soon

Tuesday September 29, 2026 3:20pm - 4:20pm BST

Arrabida

Tuesday September 29, 2026 3:20pm - 4:20pm BST
Arrabida

PSP, PSP

Topic PSP
Audience All

3:20pm BST

C101 Infusing Db2 with Agentic AI, Cloud Scale, and Quantum Resilience

Tuesday September 29, 2026 3:20pm - 4:20pm BST

Porto

Sponsors

IBM

Tuesday September 29, 2026 3:20pm - 4:20pm BST
Porto

PSP, PSP

Topic PSP
Company IBM

3:20pm BST

D101 Coming Soon

Tuesday September 29, 2026 3:20pm - 4:20pm BST

Maria

Tuesday September 29, 2026 3:20pm - 4:20pm BST
Maria

PSP, PSP

Topic PSP

3:20pm BST

F101 Coming Soon

Tuesday September 29, 2026 3:20pm - 4:20pm BST

Miragaia

Tuesday September 29, 2026 3:20pm - 4:20pm BST
Miragaia

PSP, PSP

Topic PSP

4:30pm BST

A9 Db2 zOS Utility Internals — and How to Get the Most Out of Them

Tuesday September 29, 2026 4:30pm - 5:30pm BST

Infante

Db2 utilities are fundamental to database availability, performance, and recoverability—yet many sites treat them as black boxes.
This session explores the internal behaviour of key Db2 z/OS utilities such as REORG, RUNSTATS, COPY, and LOAD. We examine how these utilities interact with data, logging, locking, and system resources, and how understanding their internals helps DBAs run them more efficiently and safely.

Description:
How Db2 utilities really run
How Db2 utilities use buffer pools, logging, IRLM, and the catalogWhy utilities should be treated like normal Db2 work, not background jobs
REORG utility explained
What happens during each REORG phase: unload, sort, reload, rebuild, and switchHow REORG affects locking and loggingWhen REORG improves performance and when it provides little or no benefit
RUNSTATS and the optimizer
Difference between table statistics and index statisticsHow histograms and sampling influence query plansWhy the timing of RUNSTATS matters for access pa

Speakers

Preetham Kannan

Director of IT Services, Rocket Software

I am a Principal Software Engineer at Rocket Software India and a Subject Matter Expert for Db2 on z/OS, with over 20 years of experience supporting critical systems across Retail, Banking, and Manufacturing industries. I’m passionate about solving real‑world Db2 challenges and... Read More →

Kiran Seela

Senior Director, Rocket Software

I am a Senior Director at Rocket Software India with more than 25 years of experience driving technical excellence in mission‑critical enterprise environments. With a strong foundation in Db2 on z/OS and enterprise architecture, I lead modernization and innovation efforts that bridge... Read More →

Tuesday September 29, 2026 4:30pm - 5:30pm BST
Infante

Track A, Technical Session

Topic Utilities
Audience Intermediate
Platform z/OS

4:30pm BST

B9 Buffer Pool tuning process with a reverse application analysis

Tuesday September 29, 2026 4:30pm - 5:30pm BST

Arrabida

The presentation is based on real life BPool tuning process for one of the Ensono clients. The "reverse application analysis" reveals the opportunities the IFCID(199) usage gives to every Db2 SYSPROG.
The standard Ensono BPool tuning process presented with a multiple charts.It also was enhanced with IFCID(199) implementation, giving amaizing results.
How to use IFCID(199), different characteristics SYNC I/O, ASYNCH I/O, GetPages can be involved into the the analysis uncovering the hidden performance bugs.

Speakers

Pawel Hryb

Senior Mainframe DB2 Systems Programmer, Ensono

Started as a System Programmer for VM/ESA and then z/OS in 1997.With Db2 v4 from 1998.For a couple of years a developer in Cobol, PL/I, REXX (ocasionally is still doing this for admin purposes :-) for a smaller polish software company.In 2005 started my longest carrier span for the... Read More →

Tuesday September 29, 2026 4:30pm - 5:30pm BST
Arrabida

Track B, Technical Session

Topic Best Practices, Modernization in Operations, Performance and Monitoring, User Stories
Audience Intermediate
Platform z/OS

4:30pm BST

C9 Mining db2mon

Tuesday September 29, 2026 4:30pm - 5:30pm BST

Porto

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

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 September 29, 2026 4:30pm - 5:30pm BST
Porto

Track C, Technical Session

Topic Best Practices, Performance and Monitoring, User Stories, Utilities
Audience All
Platform LUW

4:30pm BST

D9 More SQL tricks with Db2

Tuesday September 29, 2026 4:30pm - 5:30pm BST

Maria

SQL is a very powerful language. But to make best use of it one has to come to a "set-oriented" thinking to solve problems instead of the procedural thinking most application programmers are used to. This presentation discusses some important problems for which a set-oriented solution is initially not obvious, and shows how solutions of these problems can be developed with SQL in Db2. This presentation is a continuation with new problems and solutions of the presentation "SQL tricks with Db2" shown at IDUG EMEA 2024.

Speakers

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 →

Tuesday September 29, 2026 4:30pm - 5:30pm BST
Maria

Track D, Technical Session

Topic AppDev, Best Practices, Working with SQL
Audience All
Platform LUW

4:30pm BST

E9 Seamless SNA/VTAM migration (preconditioning for next version of Db2)

Tuesday September 29, 2026 4:30pm - 5:30pm BST

Luis

This session provides a technical overview of migrating Db2 for z/OS connectivity seamlessly from SNA/VTAM to TCP/IP. We will outline key configuration updates, and performance considerations involved in the transition, with a special focus on strengthening security through modern encryption using TLS and AT‑TLS for secure Db2 traffic. Attendees will gain practical guidance, best practices, and lessons learned to ensure a smooth and secure migration to an IP‑based infrastructure.

Speakers

Derek Tempongko

PM, 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 →

Tuesday September 29, 2026 4:30pm - 5:30pm BST
Luis

Track E, Technical Session

Topic Best Practices, Latest and Features z/OS
Audience All
Platform z/OS

4:30pm BST

F9 Fun with SQL 2026

Tuesday September 29, 2026 4:30pm - 5:30pm BST

Miragaia

The IDUG Content Committee consists of a team of dedicated volunteers who produce content for IDUG website including articles and blogs and the ever-popular DB2 Table Talk podcast. Come to this session where the attendees will be placed into teams and be given SQL Challenges to solve by the content committee. Amusing and practical challenges will be given to the contestants. Each team will have a few minutes at a keyboard to solve the current problem before the keyboard is passed to the next team. Shouting, googling, giving advice (good and bad) and general mayhem are all allowed during this fun, interactive and non-traditional session!

Speakers

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 →

Tuesday September 29, 2026 4:30pm - 5:30pm BST
Miragaia

Track F, Hands-On Lab

Audience All
Platform Cross Platform

5:30pm BST

Evening Reception

Tuesday September 29, 2026 5:30pm - 7:00pm BST

Archive

Tuesday September 29, 2026 5:30pm - 7:00pm BST
Archive

IDUG, Reception

Audience All

9:00am BST

9:00am BST

9:00am BST

10:00am BST

10:20am BST

10:20am BST

10:20am BST

10:20am BST

10:20am BST

10:20am BST

10:30am BST

10:30am BST

11:30am BST

11:30am BST

11:30am BST

11:30am BST

11:30am BST

11:30am BST

12:30pm BST

2:00pm BST

2:00pm BST

2:00pm BST

2:00pm BST

2:00pm BST

2:00pm BST

3:00pm BST

3:20pm BST

3:20pm BST

3:20pm BST

3:20pm BST

3:20pm BST

4:30pm BST

4:30pm BST

4:30pm BST

4:30pm BST

4:30pm BST

4:30pm BST

5:30pm BST

Get help with the event