MODIFY...TO REORGANIZE
To move the data and change the number of locations without changing storage structure, specify MODIFY...TO REORGANIZE.
Syntax to change locations for a table:
MODIFY tablename|indexname TO REORGANIZE WITH LOCATION = (locationname {, locationname})
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.
Last modified date: 08/29/2024