Relocate Statement
The relocate statement is used to relocate tables. This statement moves a table from its current location to the area corresponding to the specified location_name. All indexes, views, and protections for the table remain in force and valid regardless of the location of the table.
Note: The relocate statement must be used when the current disk of the table becomes too full.
This statement has the following syntax:
relocate table_name to location_name;