This document outlines a conversion path from traditional classic partitioned table spaces to partitioned-by-range universal table spaces (PBR UTS) in DB2 11 for z/OS.
The conversion from from non-UTS partitioned table spaces to partitioned-by-range UTS is important because some new enhancements and capabilities are available only for UTS table spaces.
With the release of DB2 10 for z/OS, IBM announced the traditional table space structures as “deprecated.” It is best to convert traditional classic partitioned table spaces to PBR UTS. It is best to create all new table spaces as PBG or PBR UTS.
Tip: To ensure that packages are invalidated during conversion to table-controlled partitioning, apply APAR PI36213 before using the conversion process.
17 June 2018