IDUG EMEA 2026

Db2 upgrades can look straightforward in your favourite manual, but real-world environments often tell a different story. In this session, we share practical user experiences and lessons learned from two recent Db2 upgrade projects that we undertook – moving from Db2 v11.1 to v11.5 on Windows, and from Db2 v11.5 to v12.1.3 on Linux. These upgrades involved very different setups, including single versus multiple instances, standalone databases versus HADR clusters, and the contrasting challenges between Windows and Linux platforms. We will walk through the expected and unexpected issues we encountered, highlight pitfalls not clearly documented in the manuals, and explain the workarounds and strategies that allowed us to complete the upgrades successfully.

With the push for more and more availability replacing the data in very large tables with many indexes can be problematic especially when the business is enforcing small outage windows.
This presentation outlines how we designed a process to replace the data in a 1.6bn row table in the required outage window when the initial load time was nearly 5 times the available window.

Experience the new features of SQL Data Insights Pro, including unstructured text support, model training offloading to IDAA, and incremental retraining. SQL Data Insights Pro combines unsupervised deep learning with traditional SQL queries, allowing you to run similarity, dissimilarity, clustering, analogy, and commonality AI queries on your Db2 for z/OS data.
In this hands-on lab, learn how to train models using both structured and unstructured data to gain deeper insights from your enterprise data. With the new option to run model training on IDAA, you gain greater flexibility while saving valuable system resources. You will also learn how incremental retraining can save time and resources when updating models with new data.
With these capabilities, you can uncover hidden relationships across tables and views in your Db2 data, quickly gain actionable insights to address business problems as they arise, and confidently make better business decisions. In this lab, you will see how AI