To the average application, a database is often treated as a "black box": SQL goes in, and data comes out. But for those tasked with maintaining high-performance systems, "it just works" isn't enough. When a query hangs or a system spikes in CPU, understanding the mechanics "under the hood" is the difference between a quick fix and hours of guesswork.
This presentation takes you on a chronological journey of a query’s lifecycle. We will trace the path of a single PreparedStatement from the moment it leaves a remote application, through the DRDA protocol, and deep into the Db2 engine layers. We will explore: - The Handshake: How client-server interactions and the SQLDA manage data exchange. - The Brain: Inside the Query Compiler and Optimizer—how your SQL is transformed into an executable "Plan." - The Engine Room: How the Runtime components interact with the Buffer Pools, Prefetchers, and Logger to retrieve your data. - The Return: The mechanics of the ResultSet and how data is effic
Working for IBM Db2 in support role for over 10 years. Last few years in the Advanced Problem Determination team, specializing in performance problems and operating system troubleshooting.
Wednesday September 30, 2026 4:30pm - 5:30pm BST Porto
