Best Practices for DB2 on AIX 6.1 for POWER Systems

An IBM Redbooks publication

Note: This is publication is now archived. For reference only.

thumbnail 

Published on 08 April 2010, updated 27 August 2015

  1. .EPUB (4.0 MB)
  2. .PDF (5.5 MB)

Google Play Books
Share this page:   

ISBN-10: 0738434191
ISBN-13: 9780738434193
IBM Form #: SG24-7821-00


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 and Adriana Zubiri

    menu icon

    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

     

    Others who read this also read