GiAPA SQL Observer

As SQL usage on IBM i continues to grow, optimizing frequently executed statements has become a key way to reduce server load and improve performance. 
SQL Observer video thumbnail
While IBM’s SQL Performance Center in Access Client Solutions (ACS) already offers deep analysis of Access Plans, it relies on Plan Cache data that isn’t automatically dumped due to the heavy system resources this would require.
GiAPA’s SQL Observer solves this by letting you automate and control the dumping of selected Access Plans — so you can easily capture the data you need for performance analysis without impacting system stability.