Building a smarter planet means managing and analyzing oceans of data in real time. To do this, you need database software that also exploits the latest hardware advances. DB2 automatically harnesses the massive hardware parallelism of POWER7-based systems, delivering lower costs with higher performance.
POWER7 supports up to 32 threads per chip, an unprecedented 8-fold increase over the previous generation, DB2 is specially designed to leverage and optimize multiple threads automatically, with no change to applications. Better overall performance means fewer servers and fewer licenses are needed, while deep compression means less storage is needed.
But the deep synergy between DB2 and POWER7 goes far beyond massive parallelism. DB2 automatically exploits POWER's larger page sizes, and specially locates DB2 resources to align with the system architecture. It utilizes Power systems storage keys to protect data efficiently. DB2's self-tuning memory manager monitors both DB2 and AIX memory consumption, so as to make smarter decisions. I/O priorities are aligned throughout the system. DB2's autonomics capability supports Dynamic Logical Partitioning and PowerVM, and is integrated with Tivoli System Automation.
DB2 exploits PowerHA pureScale and PowerHA SystemMirror in installations designed for scalability and high availability. The unique clustering design of DB2 provides near linear scalability, continuous availability and simplified management.
DB2 is enabled and optimized for PowerVM virtualization, reducing costs and enabling consolidation. Innovative features such as host dynamic-resource awareness, online tuning of configuration parameters, and self-tuning memory management (STMM) make DB2 well suited for PowerVM and for live partition mobility.
Both DB2 and WebSphere Application Server work in concert with AIX workload management, facilitating a comprehensive, system-wide view. And DB2's deep integration with AIX includes file system lock management and dynamic reconfiguration.
“ After extensive review of more than 2,354,000 data points covering over 4,100 closely watched production comparisons, the advantage of running DB2 on IBM Power Systems equipment is strongly supported. The advantages of the synergy between DBMS and platform translate into hard cost savings for each customer, and substantially affect the bottom line cost of ownership. ”
-- Solitaire Interglobal Ltd