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: 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.
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.
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 |
|---|---|
| Segmented (multi-table) |
FL 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. |
| 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. |