I noticed sufficient swap/paging on AIX boxes for a Pythian client. (PAGING column in topas result). When I was investigating more about this issue, I found helpful document in Vivek Sharma ‘s blog and metalink note 316533.1.
Here is excerpt from metalink: The default values for the AIX VMM are generally not appropriate for use with relational databases.
Basically metalink recommends setting proper values for minper% and maxper% OR setting lru_file_repage to 0 in order to change AIX default virtual memory management.
Interested in working with Shervin? Schedule a tech call.