GiAPA Tracks SQL Performance Issues On IBM i

March 16, 2026 Alex Woodie

Tracking down SQL performance problems with IBM i applications sometimes can be difficult, thanks to the mysterious ways that IBM’s Db2 query optimizer works. To help shine a light on changes the optimizer may suddenly make to query access plans, the IBM i performance experts behind GiAPA developed a new tool, dubbed SQL Observer.

The Db2 query optimizer is a wonder of software engineering. The IBMers who developed it deserve a ton of credit for creating a smart piece of software that keeps SQL queries running so efficiently. Users simply submit the query they want to run, and the …