It is the classic DBA dilemma: the statistics are current, the access plan looks "clean" at first glance, yet the application is dragging. When the low-hanging fruit has been picked, how do you move from intuition to evidence-based troubleshooting? This session follows a real-world "detective story" of a slow-running SQL statement originating from a Java (JDBC) application. We will move beyond basic EXPLAIN facility outputs to uncover the hidden bottlenecks that standard tools often miss. Using a step-by-step methodology, we will demonstrate how to: - Capture the invisible: Isolate specific statements from the Package Cache and extract elusive parameter marker values. - Leverage MON_GET: Use light-weight monitoring interfaces to identify where time is actually being spent (CPU vs. Wait times). - Analyze the "Why": Utilize Activity Event Monitors and Section Actuals to compare estimated vs. actual cardinalities within a live execution. - Apply Surgical Fixes: Explore advanced remediatio
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.
Tuesday September 29, 2026 11:30am - 12:30pm BST Luis
