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 …
Read more
There has never been anything wrong with IBM i job logs themselves. They are exhaustive, consistent, and remarkably detailed. When something fails, the job log contains the truth. The issue has always been consumption. Large QPJOBLOG files can run thousands of lines (or 
