IBM Db2: Investigating Automatic Storage Table Spaces and Data Skew

An IBM Redpaper publication

thumbnail 

Published on July 17, 2017, updated July 20, 2017

  1. .EPUB (0.3 MB)
  2. .PDF (1.0 MB)

Apple BooksGoogle Play Books
Share this page:   

ISBN-10: 0738456284
ISBN-13: 9780738456287
IBM Form #: REDP-5454-00


Authors: George Wangelien and Zachary Hoggard

    menu icon

    Abstract

    The scope of this IBM® Redpaper™ publication is to provide a high-level overview of automatic storage table spaces, table space maps, table space extent maps, and physically unbalanced data across automatic storage table space containers (that is, data skew). The objective of this paper is to investigate causes of data skew and make suggestions for how to resolve it.

    This paper is for Database Administrators (DBAs) of IBM Db2®; the DBAs should have general Db2 knowledge and skills. The environment used for the creation of this document is Db2 Version 11.1, and an IBM AIX® operating system. This document is based on results of testing various scenarios.

    Table of Contents

    Investigating automatic storage table spaces and data skew

    Data skew and physical data imbalance

    Prerequisites for reclaiming storage using automatic storage table spaces

    Examples of data skew, rebalancing, and reclaiming storage

    Checking table spaces for data skew

     

    Others who read this also read