Database Partitioning, Table Partitioning, and MDC for DB2 9

An IBM Redbooks publication

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

thumbnail 

Published on 23 August 2007, updated 27 August 2008

  1. .EPUB (2.2 MB)
  2. .PDF (2.7 MB)

Google Play Books
Share this page:   

ISBN-10: 0738489220
ISBN-13: 9780738489223
IBM Form #: SG24-7467-00


Authors: Whei-Jen Chen, Alain Fisher, Aman Lalla, Andrew D McLauchlan and Doug Agnew

    menu icon

    Abstract

    As organizations strive to do more with less, DB2 Enterprise Server Edition V9 for Linux, Unix, and Windows contains innovative features for delivering information on demand and scaling databases to new levels. The table partitioning, newly introduced in DB2 9, and the database partitioning feature provide scalability, performance, and flexibility for data store. The multi-dimension clustering table enables rows with similar values across multiple dimensions to be physically clustered together on disk. This clustering allows for efficient I/O and provides performance gain for typical analytical queries.

    How are these features and functions different? How do you decide which technique is best for your database needs? Can you use more than one technique concurrently?

    This IBM Redbooks publication addresses these questions and more. Learn how to set up and administer database partitioning. Explore the table partitioning function and how you can easily add and remove years of data on your warehouse. Analyze your data to discern how multi-dimensional clustering can drastically improve your query performance.

    Table of Contents

    Chapter 1. Introduction

    Chapter 2. Benefits and considerations of database partitioning, table partitioning and MDC

    Chapter 3. Database partitioning

    Chapter 4. Table partitioning

    Chapter 5. Multi-dimensional clustering

    Chapter 6. Using database partitioning, table partitioning, and MDC together

    Appendix A. Configuring DB2 to use SSH in a partitioned environment

     

    Others who read this also read