The Effect of Max Active on DB2 for i Query Performance
From the developerWorks archives
Date archived: December 19, 2016 | First published: September 19, 2011
This article explains how a high Max Active setting for a memory pool can affect the fair share of memory, thereby influencing the DB2 for i query optimizer to sometimes choose an inefficient access plan.
This content is no longer being updated or maintained. The full article is provided "as is" in a PDF file. Given the rapid evolution of technology, some steps and illustrations may have changed.