Description
The relocate statement moves a table from its current location to the location specified by locationname. You cannot relocate a table that exists on multiple locations–you must use the modify statement to move it. Relocate takes an exclusive table lock. Other sessions cannot access the table until the relocation is complete.