Purpose
Run this procedure to model map moves before a system expansion. This procedure creates three planned maps, inserts them into TDMaps.Maps, and gives them temporary names with the prefix PreExpansionMap. After the system expansion, run the PostExpansionAction procedure to rename those maps with the actual added contiguous and sparse maps. See PostExpansionAction.
Syntax
CALL [TDMaps.] CreateExpansionMaps ( 'numOfNodes', 'numOfAMPs', :ContiguousMapString, :OneAMPSparseMapString, :TotalNodesSparseMapString ) [;]
Input Parameters:
- TD_Maps
- The name of the database where the procedure is located.
- 'numOfNodes'
- The number of nodes on the expanded system.
- 'numOfAMPs'
- The number of AMPs on the expanded system.
Output Parameters:
- :ContiguousMapString
- The name of the pre-expansion contiguous map.
- :OneAmpSparseMapString
- The name of the pre-expansion 1-AMP sparse map.
- :TotalNodesSparseMapString
- The name of the pre-expansion n-AMP sparse map, where n is the number of nodes in the system.
ANSI Compliance
This is a Teradata extension to the ANSI SQL:2011 standard.
Usage Notes
- An error message is returned if numOfNodes or numOfAMPs is NULL.
- Use this procedure as many times as needed during expansion planning. No changes will be made to the database until the Mover procedure is run.