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.

In this presentation we will examine in detail the backup and recovery options available to DBAs for their Db2 environments. How to tune these utilities will be discussed and results will be reviewed from numerous tests. We will see what is the “art of the possible” from using local files, COS, Storage based copies, etc. … We will take a close look at the new version enhancements and how they can improve your backup and recovery experience.

In 2025, NatWest undertook a comprehensive reassessment of its Db2 recovery strategy to align with evolving banking regulations and to take advantage of modern platform capabilities. This review aimed to uncover limitations in existing processes, improve operational performance, and strengthen compliance.
As part of this effort, the bank evaluated Db2 utility features and automation tools that could streamline recovery activities, enforce consistent best‑practice standards, and reduce the need for continual manual tuning of utility options. Future resilience was also a priority, with the strategy designed to support NatWest’s planned adoption of Cyber Vault technology.
This session explores the challenges encountered throughout the transformation, the solutions implemented to overcome them, and the best practices that emerged—highlighting how NatWest is modernising its Db2 recovery landscape while preparing for the future.

Db2 LUW provides the capability to create partitioned tables which have a number of useful benefits. However, a current downside to the implementation on LUW is that there is no automatic built-in functionality to add partitions when needed or manage the process of adding, detaching and deleting partitions. In particular, for Production environments that require stability and availability without interruption, robust and auditable management of partitions is a critical and invaluable requirement.
In this session I will provide an overview of the design and implementation of a bespoke Unix based solution used in a high volume 24/7 transactional and warehouse database application. The presentation will include an explanation of the requirements to manage table partitions in a Production environment and will include high level diagrams of the process flow to manage the partitions; the logic to identify required partitions/timestamps to manipulate, the required commands to make changes,