Table Space Type (Create Table Space)

In Db2®, table space is either non-partitioned, or partitioned. A non-partitioned table space can be segmented (a partitioned table space cannot). Non-partitioned means that there is a 1:1 relationship between the table space and the data set defined to store the data. Partition means that many data sets are used to store the data.

To make more effective use of non-partitioned table spaces, by improving the support for multiple table definitions within the one table space, use segmented table spaces.

The maximum partition size for a partitioned table space determines the amount of data that can be stored within the table space. Large values imply the creation of multi-volume table spaces capable of storing GB of data.

Related references

• Create Table Space: Type panel