COMMON POWERUp 2026

Every SQL statement has a predefined steps that it must go through before it can complete you data base requests.  Each step taken can positively or negatively impact SQL performance - especially on transactional applications that are running the same set of SQL statements over and over again. This session will explain each step needed to run an SQL statement and the structures that Db2 creates that can impact performance. In addition, this session will review application design and settings that can impact the performance of the required steps.

Learning Objectives:

How Db2 manages the runtime execution of SQL. Differences between the 3 types of SQL: Static, Dynamic, and Extended Dynamic (ie, SQL Packages). Performance difference between SQL Full Opens & Pseudo Opens and the factors that determine when a Full Open must be performed.