AIX 6.1 Best Practices For DB2

Based on the information in the IBM Redbook Best Practices for DB2 on AIX 6.1 For Power Systems I have adopted the following starting points for AIX VMM tuning.

  • minfree=4096 for physical memory <8 GB and 8192 for memory > 8 GB
  • maxfree=minfree+512
  • maxperm%=90
  • maxclient%=90
  • minperm%=3
  • strict_maxclient=1
  • lru_file_repage=0

As with all things change slowly, document, benchmark and monitor…… Set/investigate with vmo, monitor with vmstat and svmon etc. plus your other monitoring tools.