16.10 - About Limiting the Resources for Map Reassignments - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
Release Date
April 2018
Content Type
Publication ID
English (United States)
To limit the resources used by an active map reassignment job, reduce the number of sessions processing the map use changes. In the following example, it is now 8 a.m., the system is busy, and the DBA stops 5 of the 8 Mover sessions that started at 6 p.m. last night:
CALL TDMaps.StopMoverSP(5);

StopMoverSP does not abort any ALTER TABLE requests in progress.

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