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

Teradata Vantage™ - SQL Operators and User-Defined Functions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1210-171K
Language
English (United States)

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.