IDUG EMEA 2026

Enterprise database migrations are often slowed to a crawl by their reliance on flat files. Large volumes of data must be written to disk, moved across networks, and reloaded using traditional utilities—a process that is time‑consuming, storage‑intensive, and error-prone. In migrating a legacy Oracle environment on AWS RDS to a modern, containerized Db2 platform running on OpenShift, it became clear that a fundamentally different approach was needed—one that removes the disk from the equation altogether.
This session presents a high‑performance, zero‑disk migration approach that streams data directly from the Oracle source into Db2. It walks through how to set up Db2 Federation and automate nickname creation to establish a direct data pipeline. Rather than relying on conventional SQL processing, the approach feeds a federated cursor straight into the Db2 LOAD mechanism, allowing data to be written directly into target tables with maximum efficiency.
To make this solution practical at

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.