The Effect of Max Active on DB2 for i Query Performance

From the developerWorks archives

Anil Madan

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.



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=IBM i, Information Management
ArticleID=756562
ArticleTitle=The Effect of Max Active on DB2 for i Query Performance
publish-date=09192011