This paper talks about the IBM DB2, Version 9 for Linux, UNIX, and Windows exploitation of multiple page sizes and also shares some performance results, as measured internally on IBM POWER5+ processor-based systems running the IBM AIX 5L operating system.
With the introduction of the POWER5+ processor architecture, the AIX 5L operating system added support for a new 64-kilobyte page with properties that are similar to the current default 4-kilobyte pages. In addition, AIX 5L Version 5.3 TL04 also introduced a new 16-gigabyte huge-page feature for this hardware architecture. DB2, V9 automatically exploits the 64-kilobyte pages to deliver superior performance for database applications on this platform. In addition, DB2 also supports the enablement of 16-gigabyte huge pages.