A look at new SQL Extensions delivered in releases leading up to 12.1 along with what is new in 12.1 itself. We will take a dive into how Db2 is being extended with AI capabilities including ability to access external AI models through SQL. Learn how Db2 is being extended with vector store capabilities and integrating with both open data formats and open table formats through data lake table extensions.
In this presentation we will examine in detail the backup and recovery options available to DBAs for their Db2 environments. How to tune these utilities will be discussed and results will be reviewed from numerous tests. We will see what is the “art of the possible” from using local files, COS, Storage based copies, etc. … We will take a close look at the new version enhancements and how they can improve your backup and recovery experience.
Dale McInnis is an STSM in Db2 development from the IBM Toronto Canada Lab. He has a B.Sc.(CS) from the University of New Brunswick and a Masters of Engineering(M.Eng) from the University of Toronto and is currently pursuing his PhD in computer science. Dale joined IBM in 1988 and... Read More →
Tuesday October 27, 2026 11:30am - 12:30pm EDT Magnificent 1
Twenty-one years ago, I joined IBM as a software developer. I knew nothing about AI. Today I am the AI Architect and Master Inventor of IBM Db2, leading vector search, in-database machine learning, and LLM integration. How did the journey happen? Not the way I thought it would be.
In this talk, I will share the blueprint I wish someone had given me earlier in my career: seven skills that took me from software engineer to AI architect. I will be honest about which ones moved me forward and which I learned too late. Some are technical. Most are not. They include learning AI from mentors, building communication as a craft, and learning to focus in an attention-fractured industry.
If you are an experienced software engineer wondering how to make the move into leading AI work, this talk is for you.
Technical details to Db2 LUW usage and optimization of queries There are many sessions about the EXPLAIN facility in Db2 LUW, but they all lack the concise statements to find the right SQL queries, set everything up, do the EXPLAIN and draw the right conclusions by examples and working statements to copy-and-paste.This is a back-to-basics session, enhanced with experiences from real situations and best practices.This session was presented at IDUG NA 2025 in Atlanta. It was in the Top10 of the user sessions. I will update the material to version 12.1 and preferrably include details regaring AI optimizer
Roland is installing, using and tuning Db2 on distributed since 1993 or Version 2.1 for OS/2. After working for 25+ years for ARS Computer und Consulting GmbH as a Db2 expert he is now an independent consultant.His expertise and engagement for the community allowed him to be IBM Champion... Read More →
Tuesday October 27, 2026 4:30pm - 5:30pm EDT Magnificent 1
