IDUG NA 2026

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.

In this presentation we will discuss the resiliency offerings for DB2 and how they can be combined to provide an Always On architecture.  What are the process changes required, how to I determine what needs to be done and what can I do today. The IBM Always On architecture allows you to run your client facings systems 24 by 7 by 365 with zero downtime.

Db2 delivers a wide range of tools for problem determination. Those tools range from the new Log Analysis Capability in IBM Db2 Genius Hub to classical tools that can and should be used for deeper analysis. As the Db2 community constantly welcomes new database administrators and application developers, an effecient tooling and its use is required for those new community mambers. The session will share tools and best practices for the first occurrence data capture (FODC) tools available for DBAs and developers. This session will cover the first steps in the process of problem determination and problem source identification (PD/PSI). It provides hands-on and practical examples for the strategy and process to encircle and find problems by asking the right questions.

Since 2012, the ADMIN_MOVE_TABLE stored procedure has stood for versatility. Whether you're facing extraordinary challenges or handling everyday tasks, ADMIN_MOVE_TABLE has you covered as a DBA. ADMIN_MOVE_TABLE, or AMT for short, has been continually expanded and new application areas have been added. Today, it's important to understand the architecture and design principles of AMT to understand the best use cases and avoid pitfalls. This workshop will guide you through the AMT functionality, starting with the initial intended use cases, and the most used scenarios. But even more importantly, the instructors will discuss and show pitfalls and will guide trough the problem analysis process for AMT.

Even well‑written SQL can slow Db2 for z/OS when subtle mistakes slip through. In this hands‑on lab, attendees will work with preloaded queries that showcase common pitfalls—over‑indexing, missing or stale statistics, inefficient joins, unnecessary sorting, and predicate mismatches. You’ll identify the issues, apply targeted fixes, and validate improvements using metrics, access path analysis, and supporting tools.
Beyond immediate speedups, this lab reinforces a repeatable diagnostic approach that strengthens day‑to‑day tuning and sets the stage for AI‑assisted operations—where consistent, high‑quality data enables smarter automation and more reliable outcomes.