IBM Support

DB2 for z/OS: Conversion from index-controlled
partitioning to Universal Table Space (UTS)

White Papers


Abstract

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.

Content

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.

[{"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Not Applicable","Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"10.1;11.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 June 2018

UID

swg27047046