By Jennie Chang, Paul McWilliams, and Regina Liu.
You can activate function level 508 in Db2 12 for z/OS, after you apply the PTF for APAR PH29392. Function level 508 introduces the capability to move data from multi-table simple or multi-table segmented (non-UTS) table spaces, which are deprecated, to universal table spaces (UTS).
Starting in function level 508, you can now use the new MOVE TABLE option in an ALTER TABLESPACE statement to move tables from a source multi-table table space to target partition-by-growth UTSs. This new capability provides an efficient way to migrate existing data from deprecated table spaces to supported table spaces to take advantage of new functionality.
If the data sets of the source table space are already created, a MOVE TABLE operation becomes a pending definition change that must be materialized by running the REORG utility on the source table space. You can move only one table per ALTER TABLESPACE MOVE TABLE statement, but you can materialize multiple pending MOVE TABLE operations in a single REORG.
Before moving a table, the target table space must already exist as a partition-by-growth UTS in the same database as the source table space and be defined with the following attributes:
- DEFINE NO attribute
- MAXPARTITIONS value of 1
- LOGGED or NOT LOGGED attribute that matches the source table space
- CCSID values that match the source table space
One option for using this capability is to first use the ALTER TABLESPACE MOVE TABLE statement to move all tables from the source table space to partition-by-growth UTSs:
Sign in and subscribe to always get the latest news about Db2 for z/OS from the IBM lab: http://ibm.biz/db2znews-subscribe#Db2Znews#Db2z/OS