DB2：推荐的AIX虚拟内存设置.docVIP

DB2：推荐的AIX虚拟内存设置 DB2：推荐的AIX虚拟内存设置 Question Are there recommended AIX Virtual Memory Manager settings for DB2 ? Answer While it is difficult to prescribe a standard recommendation for all virtual memory manager tunables on AIX systems running DB2, there are some important specific settings where this is possible. This document focuses primarily on parameters where non-default settings exist which are considered Best Practice. These settings apply to all versions of DB2 running on AIX 5.3 and 6.1. Recommendations: The Best Practice recommendation for DB2/AIX systems is : maxperm%=90 maxclient%=90 minperm%=3 lru_file_repage=0 These settings are implemented with the following command, which is dynamic and takes effect immediately : vmo -p -o maxperm%=90 -o maxclient%=90 -o minperm%=3 -o lru_file_repage=0 Optional: page_steal_method=1 Note that maxperm%, maxclient%, lru_file_repage, and page_steal_method are restricted tunables on AIX 6.1 and should not be tuned on that release without first consulting AIX support. The current settings can be viewed by executing the command vmo -a (On AIX 6.1, vmo -a -F includes restricted tunables). A subset of the settings (minperm%, maxperm%, maxclient%) can be viewed with vmstat -v, which does not require root authority. Definitions: Computational memory - Application memory (eg. DB2), kernel memory Permanent memory - File cache (JFS, JFS2, NFS, GPFS) Client memory - JFS2, NFS, GPFS, i.e. all permanent memory except JFS maxperm% - the threshold above which permanent memory pages will be evicted in favor of computational memory pages. AIX 5L default: 80%, AIX 6.1 default: 90% (now a restricted setting). maxclient% - the threshold above which client memory pages will be evicted in