The Effect of Max Active on DB2 for i Query Performance

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.


Leave a Reply