IDUG EMEA 2026: Full Schedule

arrow_back View All Dates

10:20am BST

A6 Strategic Efficiency: Maximizing Db2 Utilities

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

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

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

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

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

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

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

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

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

10:20am BST

10:20am BST

11:30am BST

11:30am BST

11:30am BST

2:00pm BST

2:00pm BST

2:00pm BST

2:00pm BST

3:20pm BST

4:30pm BST

4:30pm BST

4:30pm BST

Get help with the event