IDUG EMEA 2026: Full Schedule

arrow_back View All Dates

11:30am BST

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

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

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

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

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

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

IDUG EMEA 2026

11:30am BST

Thomas Baumann

2:00pm BST

Michael Tiefenbacher

2:00pm BST

Roy Boxwell

4:30pm BST

Andreas Weininger

Get help with the event