Start of change

Converting deprecated table spaces to the UTS types

For best results, convert any non-UTS segmented or partitioned table space types. The non-UTS table space types for base tables are deprecated. Although they remain supported, they will be unsupported in the future.

Before you begin

Tip: Start of change Unlike non-UTS table spaces, Db2 supports access to currently committed data in UTS. Applications that use a sequence of FETCH, DELETE, and INSERT statements in the same commit scope instead of an UPDATE statement might need to be modified to use UPDATE statements before the conversion to UTS. The reason is that a row that has been logically updated using DELETE and INSERT can re-appear in the FETCH result set before the application commits.

For more information about currently committed data access, see Accessing currently committed data to avoid lock contention.

End of change

About this task

Partition-by-growth (PBG) and partition-by-range (PBR) universal table spaces (UTS) more fully support the latest Db2 capabilities and offer other advantages over the deprecated types. For more information, see Table space types and characteristics in Db2 for z/OS.

Procedure

The procedure to use for the conversion depends on the type of existing table space:
Deprecated table space type Conversion procedure
Start of changeSegmented (multi-table)End of change Start of change

FL 508 Move the tables to new PBG table spaces.

ALTER TABLESPACE ... MOVE TABLE table-name
  TO TABLESPACE new-ts-name

For more information, see Moving tables from multi-table table spaces to partition-by-growth table spaces.

End of change
Segmented (single-table)

Convert the existing table space to PBG UTS by issuing an ALTER TABLESPACE statement with the MAXPARTITIONS clause.

ALTER TABLESPACE ... MAXPARTITIONS n
Range-partitioned Convert the existing table space to PBR UTS by issuing an ALTER TABLESPACE with a non-zero value for SEGSIZE.
ALTER TABLESAPCE ... SEGSIZE n

For more information, see Converting partitioned (non-UTS) table spaces to partition-by-range universal table spaces.

Partitioned (non-UTS) table spaces can use either index-controlled or table-controlled partitions. A table space that still uses index-controlled partitions must be converted to use table-controlled partitions before it can be converted to UTS. For more information, see Converting table spaces to use table-controlled partitioning.
Simple

See the procedures for segmented table spaces.
End of change