IBM Db2: Investigating Automatic Storage Table Spaces and Data Skew

An IBM Redpaper publication

Published 17 July 2017, updated 20 July 2017

cover image

ISBN-10: 0738456284
ISBN-13: 9780738456287
IBM Form #: REDP-5454-00
(34 pages)

More options

Rating

Authors: George Wangelien, Zachary Hoggard

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

Follow IBM Redbooks

Follow IBM Redbooks