IDUG NA 2026

Enterprises are under pressure to deliver faster insights, streamline operations, and reduce the complexity of managing large Db2 environments. Generative AI is emerging as a practical accelerator across development, administration, and performance engineering. This session will show how teams can harness AI to translate natural language questions into accurate Db2 queries, explore schemas and dependencies without digging through documentation, and diagnose performance issues with recommendations that mirror seasoned experts. We will walk through real use cases that demonstrate how GenAI can simplify workloads, cut troubleshooting time, and improve SQL efficiency, giving developers, DBAs, and performance analysts a powerful new set of tools to boost productivity and unlock the full value of Db2.

As Transport Layer Security (TLS) becomes mandatory across enterprise environments, Db2 professionals increasingly play a pivotal role in protecting data in transit—both on the client and server sides. While this session briefly reviews core TLS fundamentals such as trust models and server authentication, its primary focus is on mutual (client) certificate authentication for Db2 for z/OS. Attendees will be guided through the complete configuration workflow, including certificate management, RACF keyring setup, AT TLS policies, DDF configuration, and identity mapping for client certificates.

This session explores a practical strategy for protecting mainframe data from ransomware by combining prevention, immutable backup design, and automated recovery. While strong identity controls and privileged-access protection remain the first line of defense, organizations also need resilient recovery options when logical corruption or credential-based attacks succeed. The presentation examines the strengths and limits of software-based and hardware-enabled immutable copies, including snapshots, safeguarded copies, and cyber vault architectures, and explains why backup frequency alone does not eliminate the risk of recovering corrupted data. It then addresses the critical recovery questions every enterprise must answer: when corruption began, which recovery point is trustworthy, and how to restore business-critical data without sacrificing post-backup transactions. The session concludes with an approach that pairs immutable storage for backups and transaction logs with automated forward recovery for Db2, IMS, and VSAM, helping organizations reduce data loss, strengthen cyber resilience, and align with growing regulatory expectations for isolated, restorable backups under frameworks such as DORA and industry guidance on resilient recovery.

4 hours Hands-on-lab workshop (BYOD - Bring Your Own Device)
Transition from legacy "green screen" interfaces to a modern, high-performance environment using Visual Studio Code. This workshop provides a deep dive into Zowe Explorer and the Code4z extension pack, streamlining both system and database management. You will learn to handle z/OS core tasks - including dataset and USS file operations, job submission, and CLI terminal commands - alongside essential Db2 DBA tasks like schema management and SQL execution. We will also cover best practices for managing VS Code setups and profiles to ensure your workflow is optimized for daily enterprise use. Master these modern tools to simplify and accelerate your Db2 operations.

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.