17.10 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Operators and User-Defined Functions

Advanced SQL Engine
Teradata Database
Release Number
July 2021
English (United States)
Last Update

To ensure that all related queued actions for a group are completed by a given call to ManageMoveTablesSP, specify a value of 'N' or NULL for the parameter StopQueuedActions. If not, related tables reside in different maps and require additional data redistribution steps when running queries on those tables.

When the StopQueuedActions specified value is 'Y', any queued actions in TDMaps.ActionQueueTbl are stopped and transferred back to table TDMaps.ActionsTbl. The actions are assigned a GroupOrder representing the highest priority within the designated ActionListName. You can reschedule the actions later by calling ManageMoveTablesSP.

Any action types 'Alter' already running are not aborted.

Complete any stopped actions at a later time by calling ManageMoveTablesSP with the same TableActionList. ManageMoveTablesSP automatically resumes the execution of stopped and pending actions in the list.

Use ManageMoveTablesSP to specify a value for its TimeLimit parameter to eliminate calling StopMoveTablsSP later. StopMovesTableSP uses the same logic as the stop logic when a time limit expires.

Queued actions that are stopped are recorded as events within table ActionHistoryTbl with a value of 'Stopped' in the Status column. Unqueued items are not recorded in ActionHistoryTbl.