To move the data and change the number of locations without changing storage structure, specify MODIFY...TO REORGANIZE. For example, to spread an employee table over three locations:
MODIFY employee TO REORGANIZE
WITH LOCATION = (area1, area2, area3);
When specifying reorganize, the only valid WITH clause option is LOCATION.