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

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

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

IDUG EMEA 2026

10:20am BST

Denis Tronin

10:20am BST

Sven Heidorn

2:00pm BST

Michael Tiefenbacher

Get help with the event