Start of change

Converting deprecated table spaces to the UTS types

The non-UTS segmented and partitioned table space types are deprecated. That is, they remain supported, but support might be removed eventually, and it is best to convert them to the non-deprecated types.

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 changeFL 508 Move the tables to new PBG table spaces by following the procedure in 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 by issuing an ALTER TABLESPACE statement with the MAXPARITIONS clause.
Range-partitioned Convert the existing table space to PBR by following the procedure in Converting partitioned (non-UTS) table spaces to partition-by-range universal table spaces.
Simple See the procedures for segmented table spaces.
End of change