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.

High Performance DBATs (HP DBATS) is a very important performance feature of Db2 for DDF workloads. If applied and used intelligently this feature can generate significant savings in CPU resource consumption. This session will cover the following topics: what is a connection?; what is a DBAT (THREAD)?; thread (DBAT) pooling and DRDA inactive connections; what are High Performance DBATs; good candidate application workloads for High Performance DBATs; general guidance for configuring High Performance DBATs; performance metrics and monitoring; WLM and High Performance DBATs; Issues; Summary.

In the world of Db2 for z/OS, SQL performance tuning is one of the most critical and often most complex of DBA tasks. While static SQL has long been the standing order for traditional mainframe applications, the growing use of dynamic SQL - driven by modern applications, APIs, and distributed workloads - has changed the tuning game.Dynamic SQL’s agility and flexibility introduces a new layer of complexity that can hinder performance if not well managed and cause inconsistent performance and even be unpredictable. Dynamic SQL is becoming more prevalent as agile development and hybrid workloads become the norm. But with the flexibility of dynamic SQL comes responsibility - DBAs must adapt and develop new ways of monitoring and tuning dynamic workloads in real-time and across the application lifecycle. Colin Oakhill will share a proven approach to bring order to chaos by giving DBAs the visibility, control, and insight they need to ensure that dynamic SQL performs efficiently and predictably. Just like long-time DBAs are used to with static SQL.

Db2 professionals manage complex and mission-critical data environments where troubleshooting, performance analysis, and knowledge discovery can be time-consuming. In this session, we explore how GenAI can assist Db2 professionals by helping understand database structures, maintain environments and accelerate problem diagnosis. Through practical examples, we demonstrate how AI can act as a partner, augmenting expertise and helping teams work more efficiently while maintaining the reliability expected from enterprise Db2 systems.

This presentation will cover how to benefit from using Real Time Statistic (RTS) and Utility History. I will explain a useful established example of Real Time Statistic History, share which usecases are covered by RTS History and why RTS Temporal out of the box is not sufficient for everyone.
Second part will share some necessary preparations for Vnext and will cover one path and best practices to get rid of deprecated non-UTS tablespaces, what to consider and why utility history is really helpful. It will give some early experiences on FL509 support to migrate remaining Catalog&Directory tablespaces. Relevant topics like “workfile separation” will be covered as well.

Some aspects of Db2 for z/OS BP & GBP technology are plain as day; others, less so. Questions we get from Db2 users worldwide have highlighted for us things that a lot of folks - even very experienced Db2 people - get wrong. In this session we'll try to bring clarity to oft-misunderstood areas of Db2 for z/OS BP & GBP technology.

Generating digital certificates while installing a product like DB2 and related products on z/OS frequently involves intricate hurdles, where minor errors lead to postponed rollouts, service interruptions, and heavy manual workloads. This session breaks down the core principles of certificates while offering actionable techniques and proven methods to refine your workflow. Furthermore, we will debut an innovative utility engineered to simplify the baseline certificate configuration during mainframe software deployment, minimizing technical friction and fast-tracking your path to production.

Whether you’re evaluating data movement paths for your Db2 databases or are interested in efficiently operating your already migrated Db2 databases on Amazon RDS, we’ve got you covered. In this session, learn about data movement paths, including those with minimal downtime, for Db2 databases. Explore real-world examples to learn best practices that help ensure high availability, optimize performance, and meet your compliance needs. Bring your questions and challenges—this interactive talk offers you the opportunity to hear directly from AWS experts and collaborate with your peers. Plus, see how to supercharge your applications by integrating AWS AI/ML services like Amazon Bedrock, Amazon Sagemaker directly with RDS for Db2. Join us to turn your database into a launchpad for innovation.

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.

Managing complex Db2 LUW environments requires moving past standard practices to achieve zero-downtime availability and extreme performance. This session offers a technical blueprint for executing high-stakes cross-platform migrations from legacy AIX systems to modern Linux on Power10 and AWS/RDS cloud infrastructures. We will analyze the tuning parameters required to stabilize environments by handling 180,000 SQL statements per second, 3 TB of daily log changes, and 10,000 concurrent connections. Attendees will learn to optimize OS, storage, and network layers under strict HADR, Audits and encryption requirements. Finally, we will demonstrate how to automate database fleets using Python and leverage Db2 12.1’s native AI and Genius Hub for agentic self-healing.

This presentation will examine several key methods to configure Db2 HADR for optimal performance. We will look at the most important configuration / registry settings and discuss how they impact performance. We will also examine how to determine where the performance bottlenecks exists.

introduce knowledge learned in 2026 such as data wrapping, pacemaker, etc. Test and emphasis some experiece about old topics such as db2 auto start, db2 log path, application status with different type of interruptions,