If an abnormal end or system restart interrupts the Mover process, any transactions in progress are rolled back when the database is back online. Call CleanUpMoveTablesSP to clean up internal tables left over after the abort or restart. For example:
CALL TDMaps.CleanUpMoveTablesSP();
If the system restarts, a DBA must manually check the status of the tables that were being assigned to new maps when the restart occurred. The tables may now use new maps, but the status in ActionHistoryTbl may not have been updated yet.
The CleanUpMoveTablesSP procedure may mark tables as aborted that were completed. To remedy this, issue a SHOW TABLE request on any tables that are shown as being in progress in the ActionHistoryTbl. The map SHOW TABLE/JOIN INDEX returns indicates whether the map reassignment completed before the status was marked Complete.