The split facility changes (splits) a table partitioning storage condition and stores the data from a single RDAREA into multiple RDAREAs. Figure 13-15 Overview of the split facility (in the case of boundary value specification) and Figure 13-16 Overview of the split facility (in the case of storage condition specification) provide an overview of the split facility.

Figure 13-15 Overview of the split facility (in the case of boundary value specification)

Figure 13-16 Overview of the split facility (in the case of storage condition specification)

When a table is split, the data stored in the RDAREA that is to be split is deleted. For this reason, it is necessary to first unload the data from an RDAREA that stores data under the old partitioning storage conditions, and then load this data into the RDAREAs that will store the data under the new partitioning storage conditions. However, there is one exception: if a pre-split RDAREA is to be used as a post-split RDAREA without any change, you can keep the data that was stored before splitting without unloading and loading it.

If you do not use the pre-splitting RDAREA as a post-splitting RDAREA, you cannot keep the data that was stored in the pre-splitting RDAREA.

The combine facility changes (combines) partitioning storage conditions for a table and stores data from multiple RDAREAs into a single RDAREA. Figure 13-17 Overview of the combine facility (in the case of boundary value specification) and Figure 13-18 Overview of the combine facility (in the case of storage condition specification) provide an overview of the combine facility.

Figure 13-17 Overview of the combine facility (in the case of boundary value specification)

Figure 13-18 Overview of the combine facility (in the case of storage condition specification)

When RDAREAs are combined, the data stored in the RDAREAs that are to be combined is deleted. For this reason, it is necessary to first unload the data from the RDAREAs to be combined that store data under the old partitioning storage conditions, and then to load this data into the RDAREA that will store the data under the new, combined partitioning storage condition. However, there is one exception: if one of the pre-combination RDAREAs is to be used as the post-combination RDAREA, you can keep the data that was stored in it before combining.

If you do not use a pre-combining RDAREA as the post-combining RDAREA, you cannot keep the data that was stored in any of the pre-combining RDAREAs. To set the data that was stored in the pre-combining RDAREAs in the newly added RDAREA, you must unload the data from all RDAREAs before combining, and then load this data after combining.