16.10 - Restart Cleanup during the Mover Process - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)
If an abort 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 needs to 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 actually 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/HASH INDEX returns indicates whether or not the map reassignment completed before the status was marked Complete.

For more information on CleanUpMoveTablesSP, including the syntax, see SQL Functions, Operators, Expressions, and Predicates.