IDUG EMEA 2026

This presentation will provide the ongoing success story Db2 z/OS Version 13 and covers the latest experiences with Db2 13 at Commerzbank AG. It will talk about some key important areas which are essential for the success and how to prevent some known avoidable pitfalls. We share the important latest experiences of the last 12 months, explains the upcoming and validated best practices in several key areas. This session will also dive into Function Level dependencies, maintenance aspects, some tooling dependencies, and some performance aspects as well as base utilities and system functionalities.

OpenTelemetry is rapidly becoming the industry standard for application observability —offering a unified approach across distributed platforms. But did you know that even mainframe applications and subsystems can now be part of this modern observability ecosystem?
In this session, we’ll dive into what OpenTelemetry means from a Db2 for z/OS perspective. You’ll learn its core concepts, why they matter for mainframe environments, and how to take your first steps toward OpenTelemetry-based end-to-end monitoring of Db2 for z/OS applications with minimal effort. We’ll also highlight common pitfalls and explain why OpenTelemetry complements — rather than replaces — traditional Db2 monitoring.

Db2 for z/OS environments generate thousands of system messages and codes every day, only a small subset of which indicate truly critical conditions. This session focuses on how Db2 DBAs can effectively identify, interpret, and respond to critical events that threaten system availability, data integrity, resource consumption, and security. Starting from the structure and meaning of Db2 messages, reason codes, and return codes, the presentation walks through real-world scenarios such as log space exhaustion, storage shortages, dataset access failures, and recovery-related errors. Attendees will learn how to distinguish symptoms from root causes and how timely detection can prevent hangs, outages, and data loss. The session emphasizes a proactive monitoring and troubleshooting approach based on SYSLOG and Db2 address space analysis. It is aimed at Db2 DBAs who want to strengthen operational resilience, improve incident response, and consistently meet SLA and recovery objectives.

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.

Think you’re in the elite 1% of Db2 for z/OS pros? Or just starting your journey to the top? Ditch the slides for a high-stakes, 1% Club style tournament! We’ll scale the heights of Db2 knowledge together, from SQL basics to zIIP offloading and hex-level internals. It’s a no-shame game where every wrong answer leads to a deep-dive technical debrief. Come for the fun, stay for the insights, and level up your Db2 skills!