Purpose
MoveTablesSP executes a worker session that consumes and executes actions from table ActionQueueTbl, which was populated by a prior call to ManageMoveTablesSP. You can make multiple concurrent calls to MoveTableSP, where the workers fetch and perform actions in parallel from the shared queue.
Syntax
CALL [TDMaps.] MoveTablesSP ( 'ActionList', 'DatabaseName', 'TableName', 'TargetMapName', 'ColocationName' ) [;]
- TDMaps.
- The name of the database.
- 'ActionList'
- The options are 'P' for the ParallelTableActionList, or 'S' for the SerialTableActionList.
- 'DatabaseName'
- The database in which the object is defined.
- 'TableName'
- Name of table, join index, or hash index defined in 'DatabaseName'.
- 'TargetMapName'
- Name of the map where the object is moved.
- 'ColocationName'
- The colocation name string for the table.