IDUG NA 2026

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, highlighting the critical distinction of query access paths between iterative and merge strategies that are key to achieving successful query parallelism. Practical use cases will illustrate these principles in action, showcasing tangible improvements. Additionally, we will discuss how ChatGPT can assist in the query tuning processs. Join us to rediscover the power of parallelism and leverage zIIP processors to their fullest potential.

SQL Data Insights (SQL DI) in Db2 13 for z/OS brings built‑in AI directly into the database, enabling organizations to discover patterns, detect anomalies, and generate insights using familiar SQL—without moving data or building complex pipelines.
This session provides practical guidance on getting started with SQL DI, beginning with Db2 instrumentation data as a high‑value entry point. It will also demonstrate how to extend insights by ingesting VSAM data through Data Virtualization Manager.
In addition, the session highlights recent SQL DI enhancements, including a unified embedding model, SQL-based AI access, and incremental training capabilities—enabling teams to seamlessly embed AI into existing Db2 workflows.
The session concludes with an overview of Industry Starter Kits, featuring prebuilt datasets, vector tables, and AI queries that accelerate adoption and help organizations quickly realize high‑value use cases.

This presentation will demonstrate how to find, analyze and tune the top 40 expensive queries. Special emphasis will be on finding the cursors that could benefit from multi-row fetch. In addition, discussions on designing perfect indexes, MQTs and AQTs, along with manual query rewrite, SQL exploitation and most important, proper use.