IDUG EMEA 2026

In this session, I provide an inside look at how Db2 is used, operated, and evolved within SD Worx, a payroll/HR service provider, running running a mixed COBOL and .NET application landscape.
The presentation walks through the Db2 environment at SD Worx and illustrates real-world production workloads (with its struggles). We'll explore trends in Db2 growth, the impact of data integration (including the migration from IDMS), and how replication technologies are used to offload reporting, analytics, and decentral processing without impacting core workloads.
Special attention is given to Db2 Connect and connection management challenges in distributed .NET environments. Including real‑world P1 incidents (don't trust your distributed teams blindly!) and how to avoid them using Db2 Profiles, driver configuration and monitoring.Db2 Profiles are also used to regain control over legacy clients and get rid of the soon to be deprecated (and this time for real!) synonyms, which will be explained