16.20 - CreateExpansionMaps - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Operators and User-Defined Functions

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
April 2020
Content Type
Administration
Programming Reference
Publication ID
B035-1210-162K
Language
English (United States)

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



Input Parameters:

TD_Maps
The name of the database where the procedure is located.
'numOfNodes'
The number of nodes on the expanded system.
SMALLINT is the allowed data type.
'numOfAMPs'
The number of AMPs on the expanded system.
SMALLINT is the allowed data type.

Output Parameters:

:ContiguousMapString
The name of the pre-expansion contiguous map.
VARCHAR is the allowed data type.
:OneAmpSparseMapString
The name of the pre-expansion 1-AMP sparse map.
VARCHAR is the allowed data type.
:TotalNodesSparseMapString
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.

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.