IDUG NA 2026

In this engaging and experience-rich session, Craig Mullins shares hard-earned lessons from four decades working with Db2 in real-world environments. The session goes beyond theory to explore what actually works—and what doesn’t—when managing, tuning, and evolving mission-critical Db2 systems and applications. Drawing on stories from the field, Craig highlights key pitfalls, performance insights, and practical strategies that have stood the test of time, offering attendees actionable guidance they can apply immediately in today’s complex data landscape.
In essense, this session is a walkthrough of things I have learned throughout my career as a developer, a DBA, an industry analyst, and a consultant. It will discuss best practices and experiences with an eye toward offering practical advice for all Db2 practitioners.

Make sure you have all the tools to write functional SQL using all the features of recent versions of Db2. Stop writing SQL like it's the '90s.

Amazon RDS for Db2 addresses growing demand for Db2 cloud migration by delivering a fully managed service with push-button deployment — provision a production-ready Db2 instance in minutes, not days. Automated patching, backups, scaling, and failover eliminate undifferentiated heavy lifting. This deep dive covers RDS for Db2 through the Well-Architected Framework: Operational Excellence, Security, Reliability, Performance Efficiency, and Cost Optimization. Attendees learn how a managed service reduces admin burden, improves uptime, and frees teams to focus on innovation. Leave with a blueprint for modernizing Db2.
Self-managed Db2 means manual patching, complex HA, and rising costs. Amazon RDS for Db2 fixes that — deploy production-ready Db2 in minutes with a fully managed service.This deep dive covers RDS for Db2 through the Well-Architected Framework: Operational Excellence (automated patching, backups, monitoring), Security (encryption, IAM, VPC), Reliability (Multi-AZ, cross-region DR), Performance Efficiency (right-sizing, storage tuning), and Cost Optimization (Reserved Instances, TCO savings vs. self-managed).Live demos and customer patterns show how to provision, secure, and optimize RDS for Db2 for production. Migrating from Linux or AIX? Optimizing an existing deployment? Leave with a well-architected blueprint for Db2 as a managed service on AWS.

This session will share experience from client studies and engagements: sharing proven recommended best practice; learning good, bad and ugly; providing answers ti important, frqeeunt or difficuly questions. This session will cover the following topics: Complacency about component failure and ability to absorb workload failover in a dat asharing environment; missed opportinity for elapsed time performance improvementnfor skip sequnetial batch processing; misteps in evaluating the performance benenfit of CICS-Db2 thread reuse and RELEASE(DEALLOCATE); SQL coding to avoid update anomaly when using cursor stability isolation; misadventures when using High Performance DBATs;monitoring WLM policy achievement; options for mass data recovery following logical data recovery and data loss; performance issue with remote DDF batch workload; tuning ogf GBPs; thorough Disaster Restart testing.

There have been so many enhancements in Db2 SQL for developers in the last 3 or 4 versions that many developers have never really taken advantage of. This presentation picks my personal favorites that I believe all developers should get knowledgeable on and possibly applied to current and future applications. Developers should be informed of all of newer features in Db2 and this presentation is a great summary for this topic. When it comes to performance, often times the answer to better performance is rewriting queries different ways, and redesigning programs differently. Attendees will leave with a better understanding of some great SQL enhancements, application table designs, along with getting stronger in the SQL language. This is a great session for developers on Db2 LUW or Db2 z/OS. Developers 'Get Empowered'.

The blessing of SQL is: when logically correct it will return an answer. Unfortunately, this is also the curse. Depending on how you write your SQL, you give the optimizer more or fewer choices .In this session we will go over understanding performance basics and common made SQL mistakes and the impact they have on the optimizer's choices.
Bring our application DBA's and developers to this session to train them and avoid common SQL performance pitfalls

In today's world, dynamic SQL usage is on the rise.The presentation will show ways to enhance dynamic SQL performance,Focusing on CSWL feature with actual big savings achieved.Skeleton:Dynamic vs static SQL Literals vs parameter markersDSC Cost vs benefit LimitationsCSWL How does it work Cost vs benefit Where can I use it Real life savings from mataf Limitations Should I use it globally?