1.

What Are Simple, Segmented And Partitioned Table Spaces ?

Answer»

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.

Simple Tablespace:

Segmented Tablespace:

Partitioned Tablespace:


Discussion

No Comment Found

Related InterviewSolutions