Table Spaces

A table space is a logical entity used to define where tables and indexes will be stored within a database. All DB2 tables and indexes reside in table spaces, allowing complete control over where the table and index data are physically stored.

A table space can be created using one or more underlying physical storage devices called containers. This provides the ability to create a physical database design that provides optimal performance in any physical environment.

Details about the table spaces in a database can be obtained using:

  1. GET SNAPSHOT FOR TABLESPACES ON <database name>

  2. LIST TABLESPACES

Containers

A table space is a logical database entity; table space containers are the physical storage associated with a table space. A ...

Get Advanced DBA Certification Guide and Reference for DB2® Universal Database™ v8 for Linux®, UNIX®, and Windows® now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial