IDUG EMEA 2026

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.

As IBM continues to deliver new utility enhancements, it's important to take a step back and review what options really matter and how to get the best performance and availability from utility executions. This session will explain general recommendations for utility performance as well as look at specific utilities to see how they can be optimised to make a real difference to performance, application availability and usability.

Quickly and Easily solve your most demanding Db2 utility challenges using the latest capabilites available in the BMC AMI Db2 utilities. This presentation covers the latest enhnacements in the BMC utilities for Db2 zOS. Come learn how BMC customers solve their hardest operational problems every day using the Db2 utilities from BMC. Gain deep insights on the advanced performance, useability and automation features available today in the BMC Db2 Utilities that set us apart from the competion.

Db2 utilities are fundamental to database availability, performance, and recoverability—yet many sites treat them as black boxes.
This session explores the internal behaviour of key Db2 z/OS utilities such as REORG, RUNSTATS, COPY, and LOAD. We examine how these utilities interact with data, logging, locking, and system resources, and how understanding their internals helps DBAs run them more efficiently and safely.

Description:
How Db2 utilities really run
How Db2 utilities use buffer pools, logging, IRLM, and the catalogWhy utilities should be treated like normal Db2 work, not background jobs
REORG utility explained
What happens during each REORG phase: unload, sort, reload, rebuild, and switchHow REORG affects locking and loggingWhen REORG improves performance and when it provides little or no benefit
RUNSTATS and the optimizer
Difference between table statistics and index statisticsHow histograms and sampling influence query plansWhy the timing of RUNSTATS matters for access pa