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.
Want to talk with an expert? Schedule a call with our team to get the conversation started.