IDUG EMEA 2026

Db2 and IMS database administrators on IBM Z are increasingly expected to support modern, AI‑enabled business initiatives while continuing to manage complex, mission‑critical transactional environments. Traditional operational workflows—often manual and reliant on deep individual expertise—can limit consistency and scalability as systems evolve.
This session introduces IBM Z Database Assistant, which brings agent‑assisted intelligence into Db2 and IMS administration. By combining DBA‑centric AI agents with context‑driven dashboards, the Database Assistant helps DBAs better understand database behavior, evaluate operational impact, and take informed actions—reducing the need for manual interpretation across multiple tools.
Attendees will see how natural language interaction can simplify common DBA tasks, how intelligent SQL tuning can improve transactional workload efficiency, and how AI agents can assist with faster problem diagnosis across Db2 and IMS environments.

This presentation explores the nuances of query parallelism in Db2, focusing on how to effectively tune queries for optimal zIIP exploitation. Attendees will gain insights through real-world query examples that will illustrate these principles in action, showcasing tangible improvements. Additionally, we will discuss how ChatGPT can assist in the query tuning processs. Join me to rediscover the power of parallelism and leverage zIIP processors to their fullest potential.

Many Db2 DBAs treat the z/OS Workload Manager (WLM) as "the system programmer’s problem," but WLM is actually the engine that determines if your SQL succeeds or fails. In this session, we will demystify WLM from a DBA’s perspective. We’ll cover the basics: defining service classes, importance, and goals. You will learn how WLM distinguishes between "local" work (like batch) and "remote" SQL (using enclaves), and why this matters for your daily performance monitoring. We’ll wrap up with simple best practices and a look at how to spot WLM issues before they become outages. Join this session to learn how to speak the language of WLM and ensure your Db2 workload gets the priority it deserves.

The presentation is based on real life BPool tuning process for one of the Ensono clients. The "reverse application analysis" reveals the opportunities the IFCID(199) usage gives to every Db2 SYSPROG.
The standard Ensono BPool tuning process presented with a multiple charts.It also was enhanced with IFCID(199) implementation, giving amaizing results.
How to use IFCID(199), different characteristics SYNC I/O, ASYNCH I/O, GetPages can be involved into the the analysis uncovering the hidden performance bugs.