Monday, November 25, 2013

What are simple, segmented and partitioned table spaces ?

Simple Tablespace: Can contain one or more tables Rows from multiple tables can be interleaved on a page under the DBAs control and maintenance.

Segmented Tablespace:Can contain one or more tables Tablespace is divided into segments of 4 to 64 pages in increments of 4 pages. Each segment is dedicated to single table. A table can occupy multiple segments.

Partitioned Tablespace:Can contain one table Tablespace is divided into parts and each part is put in a separate VSAM dataset.

0 comments:

Post a Comment