IDUG NA 2026

When a Db2 or IMS issue occurs, resolution often relies on time-critical manual analysis. This session explores how agentic AI is evolving the operational model for IMS and Db2—moving beyond scripted automation toward more adaptive, AI-assisted approaches for handling complex runtime scenarios. Through a live demo grounded in real client feedback from a large financial services organization, we demonstrate how these approaches can reduce time to resolution and improve operational efficiency. We also examine how AI-assisted decisioning can support routine maintenance, ensuring actions are recommended within defined rules, governance boundaries, and measurable value.
Co-presented with Anshul Agrawal, this technically focused session will also be submitted to IBM TechXchange.

Db2 Z and the CIA is a powerful informational combination. To be clear, the CIA is the Compliance Information Analysis product available for free to many users of Db2 Z (if you have Broadcom products). Broadcom introduced the CIA as a subproduct of ACF2. It is now an independent product available to most users of their products. The CIA provides a series of Db2 tables that can contain all the information from your external-security-manager (ESM), whether it is ACF2, RACF, or TopSecret. Once your ESM is loaded into the CIA, it is relatively more accessible to the curious end-user! SQL SELECT can be used to easily build interesting and useful and focused reports about your security configuration. This presentation will go over the basics of mainframe security and the basics of the CIA and how to build and populate. Finally, interesting CIA tables and views (and sample SELECTs) will be highlighted to show why it is useful.

AI agents are moving beyond chatbots and code suggestions. The next frontier is agentic AI — systems that autonomously plan multi-step tasks, invoke tools, handle branching logic, and execute end-to-end workflows with minimal human intervention. This session shows how that capability applies directly to Db2 for z/OS operations today, using tooling already available in your environment.
The architectural foundation is simpler than it appears: a well-documented CLI is already an agent interface. The Zowe CLI ecosystem — including its Db2 plugin and the richer vendor-supplied extensions published to the Zowe conformance catalog — gives an AI agent a complete, auditable means to act on the mainframe. The agent does not wait for step-by-step instructions; it reasons over the task, selects the right tool from its available plugin set, chains the necessary operations, and executes.
This session presents a layered agent architecture purpose-built for Db2 workflows in production environments:
Execution layer: A base skill encoding the Zowe CLI interface — translating agent intent into exact, logged commands with safe defaults enforcedDomain layer: A Db2-specific reasoning layer encoding your object model, naming conventions, environment topology, and operational runbooks — the institutional knowledge that typically lives in a senior DBA's headGuardrail layer: Explicit constraints on what the agent executes autonomously versus what requires human sign-off, scoped by environment, subsystem, or operation classWe will demonstrate this using vendor-supplied database management plugins available in the Zowe ecosystem. By exposing operations like DDL generation, schema comparison across subsystems, validation, deployment, and object migration through a CLI interface, an agent can autonomously execute workflows that previously required manual expert coordination — generating DDL for a target object, comparing it against a reference subsystem, validating dependencies, and staging the deployment artifact as a single orchestrated task.
We will also show how the compounding architecture scales across your full mainframe stack. Institutional knowledge encoded once — for Db2, for your SCM tool, for your CICS or MQ environment — becomes a reusable agent capability. Each domain layer builds on the same execution foundation, and the agent chains them together as the workflow demands.
Attendees will leave with a concrete architecture for deploying agentic AI on Db2 z/OS, practical guardrail patterns that make autonomous execution safe in production, and a clear understanding of how the depth of the Zowe plugin ecosystem — open-source and vendor-supplied alike — becomes a direct multiplier for what an AI agent can accomplish.

IBM Db2 offers a wide range of AI features, both built-in and external tools, for creating AI systems and solutions. These include over 200 built-in AI stored procedures and tools that work seamlessly with open-source AI ecosystems. In this workshop, participants will explore Db2’s AI support and use a selection of these features to implement practical AI models. The workshop consists of two parts. In the first module, participants will learn how to develop a supervised AI model using Db2’s built-in AI stored procedures. The entire model development and usage will be done using SQL within the database. In the second module, participants will learn how to create a Python model using popular Python packages outside of the database, and then deploy that model back into a Db2 database. By the end of the workshop, participants will have gained fundamental skills and hands-on experience in utilizing these AI capabilities. They will be able to apply these skills to their future AI projects. This workshop is designed to be beginner-friendly and does not require participants to have extensive knowledge in AI. Basic SQL skills and some Python programming skills are sufficient for attending and benefiting from this workshop.

This 4 hours workshop - knowledge transfer session will be conducted by following presenters: Toine Michielse, Michal Bialecki, Emil Kotrc, Denis Tronin
In the world of Db2 for z/OS, "set it and forget it" is a recipe for performance degradation and wasted storage. As data volumes explode and batch windows shrink, traditional housekeeping—REORG, RUNSTATS, and IMAGE COPY—must evolve from manual chores into a streamlined, automated strategy.
This deep-dive workshop provides a comprehensive blueprint for modern Db2 maintenance. We will move past the basics to explore how to balance object availability with optimal performance. Attendees will learn how to leverage the latest utility enhancements to reduce CPU consumption, manage multi-terabyte objects, and ensure that the optimizer always has the "ground truth" through intelligent statistics collection.