Best Practices for DB2 on AIX 6.1 for POWER Systems

An IBM Redbooks publication

Published 08 April 2010, updated 27 August 2015

cover image

ISBN-10: 0738434191
ISBN-13: 9780738434193
IBM Form #: SG24-7821-00
(426 pages)

Authors: Rakesh Dash, Bernard Goelen, Vasfi Gucer, Rajesh K Jeyapaul, Sunil Kamath, Naveen Kumar Bharatha, Michael Kwok, Anupama Padmanabhan, Punit Shah, Basker Shanmugam, Sweta Singh, Amar Thakkar, Adriana Zubiri

Abstract

This IBM® Redbooks® publication presents a best practices guide for DB2® and InfoSphere™ Warehouse performance on a AIX® 6L with Power Systems™ virtualization environment. It covers Power hardware features such as PowerVM™, multi-page support, Reliability, Availability, and Serviceability (RAS) and how to best exploit them with DB2 LUW workloads for both transactional and data warehousing systems.

The popularity and reach of DB2 and InfoSphere Warehouse has grown in recent years. Enterprises are relying more on these products for their mission-critical transactional and data warehousing workloads. It is critical that these products be supported by an adequately planned infrastructure. This publication offers a reference architecture to build a DB2 solution for transactional and data warehousing workloads using the rich features offered by Power systems.

IBM Power Systems have been leading players in the server industry for decades. Power Systems provide great performance while delivering reliability and flexibility to the infrastructure.

This book presents a reference architecture to build a DB2 solution for transactional and data warehousing workloads using the rich features offered by Power systems. It aims to demonstrate the benefits DB2 and InfoSphere Warehouse can derive from a Power Systems infrastructure and how Power Systems support these products.

The book is intended as a guide for a Power Systems specialist to understand the DB2 and InfoSphere Warehouse environment and for a DB2 and InfoSphere Warehouse specialist to understand the facilities available for Power Systems supporting these products.

Table of contents

Chapter 1. Introduction
Chapter 2. AIX configuration
Chapter 3. Storage layout
Chapter 4. Monitoring
Chapter 5. LPAR considerations
Chapter 6. Virtual I/O Server
Chapter 7. Live Partition Mobility
Chapter 8. Workload Partitioning
Appendix A. System health check

Follow IBM Redbooks

Follow IBM Redbooks