16.20 - getNumAMPs() - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

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

Returns the total number of AMPs that are in online or hold state within the same node as the invoking AMP.

If this method is invoked from a table operator that is associated with a map, then getNumAMPs() returns the total number of AMPs that are in online or hold state within the specified map and on the same node as the invoking AMP.