IDUG EMEA 2026

In the modern era of data-driven decision-making, leveraging the power of mainframe data, such as Db2 on z/OS, can provide deep insights into business operations. However, visualizing this data and utilizing advanced analytics can often seem challenging. This session will explore how Python libraries, along with machine learning tools, can bridge the gap by providing intuitive and powerful solutions to visualize and analyze Db2 data on z/OS.
We will begin by discussing the fundamentals of accessing Db2 data on z/OS using Python library ibm_db. Once data is ready we will explore popular python libraries to create clear and informative visualizations.
The session will then dive into the integration of machine learning tools, to uncover hidden patterns in the data, perform predictive analytics, and gain deeper insights.

Enterprises are under pressure to deliver faster insights and streamline operations - the ultimate Boss Fight of managing large Db2 for z/OS environments. Generative AI is your new power-up for development and administration and your secret weapon against complexity. This session will show how to flip on the Auto-Pilot to tune SQL with expert-level precision, master complex schema management, and drive utilities intelligently for object maintenance. We'll walk through real speedruns (use cases) that demonstrate how GenAI simplifies workloads, cuts troubleshooting time, and improves efficiency, giving your team the cheat codes to unlock Db2's full value and achieve the High Score in productivity.

SQL is a very powerful language and can get complex. There are many ways of writing semantically equivalent queries.SQL SQL may be written by database users or ncluding external tools and these may not always be the most suitable for the Db2 engine for performance as written. The Query Rewrite component in Db2 helps towards simplifying this task for the user or external toolThe Query Rewrite (one of two optimizer components, the other being the Plan Optimizer) automatically rewrites queries within Db2 towards a better performing version for the Plan Optimizer and the Db2 execution engine.
This session delves into how AI is used to help the Query Rewrite component make better decisions. We present the challenges involved, how we tackle these challenges and touch on our next steps to transform the Query Rewrite component to exploit AI to make it even more powerful than it currently is.