CreateExpansionMaps | SQL Operators & User-Defined Functions | Teradata Vantage - CreateExpansionMaps - Advanced SQL Engine - Teradata Database

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.

ANSI Compliance

This is a Teradata extension to the ANSI SQL:2011 standard.

Syntax

CALL [TDMaps.] CreateExpansionMaps (
  'numOfNodes',
  'numOfAMPs',
  :ContiguousMapString,
  :OneAMPSparseMapString,
  :TotalNodesSparseMapString
) [;]

Syntax Elements

TD_Maps

Input parameter. The name of the database where the procedure is located.

numOfNodes

Input parameter. The number of nodes on the expanded system.

SMALLINT is the allowed data type.

numOfAMPs

Input parameter. The number of AMPs on the expanded system.

SMALLINT is the allowed data type.

ContiguousMapString

Output parameter. The name of the pre-expansion contiguous map.

VARCHAR is the allowed data type.

OneAmpSparseMapString

Output parameter. The name of the pre-expansion 1-AMP sparse map.

VARCHAR is the allowed data type.

TotalNodesSparseMapString

Output parameter. The name of the pre-expansion n-AMP sparse map, where n is the number of nodes in the system.

VARCHAR is the allowed data type.

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.