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

SQL Operators and User-Defined Functions
Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2023-04-27
dita:mapPath
qqu1556127655717.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1210
lifecycle
previous
Product Category
Teradata Vantage™

Purpose

Run this procedure after a system expansion to rename the temporary, planned maps created with the CreateExpansionMaps procedure to the actual maps to be used in the Mover procedures. This procedure removes the prefix PreExpansionMap before the map names. This procedure is necessary if you ran the Advisor procedures before the system expansion and are not going to run them again afterward.

Syntax

CALL [TDMaps.] PostExpansionAction ('numOfNodes', 'PostExpansionMap') [;]
TD_Maps
The name of the database where the procedure is located.
'numOfNodes'
The number of nodes in the expanded system.
SMALLINT is the allowed data type.
'PostExpansionMap'
The name of the contiguous map after the system expansion.
VARCHAR is the allowed data type.

ANSI Compliance

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

Usage Notes

An error message is returned in the following cases:
  • If numOfNodes or PostExpansionMap is NULL.
  • If no row is found in TDMaps.Maps because the user has not run the CreateExpansionMaps procedure.
  • If numOfNodes in the CreateExpansionMaps procedure is not the same as numOfNodes in the PostExpansionAction procedure.