Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What are simple, segmented and partitioned table spaces ?

April 26, 2017partitioned segmented simple Table

0

Posted

What are simple, segmented and partitioned table spaces ?

2 Answers

0

10 Posted

A121) Simple Tablespace: Can contain one or more tables. Rows from multiple tables can be interleaved on a page under the DBA’s 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

Posted

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.