16.10 - About Limiting the Resources for Map Reassignments - 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)
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.