IDUG EMEA 2026

This 4 hours workshop - knowledge transfer session will be conducted by following presenters: Toine Michielse, Michal Bialecki, Julia Carter, Emil Kotrc, Denis Tronin
In the world of Db2 for z/OS, "set it and forget it" is a recipe for performance degradation and wasted storage. As data volumes explode and batch windows shrink, traditional housekeeping—REORG, RUNSTATS, and IMAGE COPY—must evolve from manual chores into a streamlined, automated strategy.
This deep-dive workshop provides a comprehensive blueprint for modern Db2 maintenance. We will move past the basics to explore how to balance object availability with optimal performance. Attendees will learn how to leverage the latest utility enhancements to reduce CPU consumption, manage multi-terabyte objects, and ensure that the optimizer always has the "ground truth" through intelligent statistics collection.

Db2 delivers a wide range of tools for problem determination. Those tools range from the new Log Analysis Capability in IBM Db2 Genius Hub to classical tools that can and should be used for deeper analysis.
As the Db2 community constantly welcomes new database administrators and application developers, an effecient tooling and its use is required for those new community mambers.
The session will share tools and best practices for the first occurrence data capture (FODC) tools available for DBAs and developers. This session will cover the first steps in the process of problem determination and problem source identification (PD/PSI). It provides hands-on and practical examples for the strategy and process to encircle and find problems by asking the right questions.