COMMON POWERUp 2026

With Symmetric Multiprocessing (SMP) now available as a no-charge feature in IBM i, you've gained access to a powerful feature that can significantly improve the speed of query execution. However, SMP must be approached carefully, as improper usage may produce lackluster results. This session will cover the inner workings of SMP, when to utilize SMP, and tools for controlling system-wide SMP usage.

Learning Objectives:

`- Understand how the SQL Query Engine utilizes SMP to accelerate query execution - Understand what workloads benefit most from SMP - Understand the controls available to the Database Engineer to control SMP