Partition-by-range (UTS) table spaces

partition-by-range (UTS) table spaces (which are also sometimes called rRange-partitioned universal table spaces) use a segmented table space organization and are based on partitioning ranges.

A range-partitioned universal table space contains a single table, which makes it similar to a partitioned (non-UTS) table space. You can create an index of any type on a table in a range-partitioned (UTS) table space.

You can implement range-partitioned (UTS) table spaces by specifying the NUMPARTS keyword, or both keywords SEGSIZE and NUMPARTS on a CREATE TABLESPACE statement. After the table space is created, activities that are already allowed on partitioned (non-UTS) or segmented (non-UTS) table spaces are allowed on the range-partitioned (UTS) table space. You can specify partition ranges for a range-partitioned (UTS) table space on a subsequent CREATE TABLE statement.

If you create a table space by specifying NUMPARTS without specifying the SEGSIZE or MAXPARTITIONS options, DB2® creates a range-partitioned universal table space. The default table space SEGSIZE value is 32.