Stop Map Reassignments Abruptly| Teradata Vantage - 17.00 - 17.05 - Stopping Map Reassignments Abruptly - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval
To stop a map reassignment job immediately, call the procedure StopMovesTablesSP and specify Y for the StopQueuedActions parameter. For example:
CALL TDMaps.StopMoveTablesSP('Y',
		 :NumActionsStopped, :NumQueuedActionsStopped);
The ActionHistoryTbl records any already queued actions that are stopped .
If a table group is interrupted during the map reassignment process, related tables may be assigned to different maps and may reside on different AMPs for a long time, slowing down request processing. For this reason, Teradata recommends stopping map reassignments gracefully, allowing groups of related tables to stay together.

Do not stop the map reassignment job by issuing ABORT SESSION LOGOFF. That causes the manager session to hang. Calling StopMoveTablesSP releases the manager session. After running StopMoverSP, you need to manually abort the worker sessions.

For more information on StopMoveTablesSP, including the syntax, see Teradata Vantage™ - SQL Operators and User-Defined Functions, B035-1210.