Explain about different table spaces.

There are thee types of table spaces, namely Simple table space, Segmented table space and Partitioned table space.

1. Simple Table space:
A simple table space can contain one or more tables. The rows from multiple tables can be interleaved on a page under the control and maintenance of DBA
2. Segmented table space:
It also contains one or more tables. Each table space is divided into 4 to 64 pages length of segments in increments of 4 pages. A segment is dedicated to a single table. One table can occupy multiple segments.
3. Partitioned table space:
One table is accommodated in partitioned table space. Table space is divided into different parts and every part is put in a separate VSAM dataset.