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

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.

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.