16.20 - Example: Identifying Which AMPs are in a Contiguous Map - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Operators and User-Defined Functions

Advanced SQL Engine
Teradata Database
Release Number
Release Date
April 2020
Content Type
Programming Reference
Publication ID
English (United States)

Use the function SYSLIB.ContiguousMapAMPs to view the AMPs in a contiguous map.

In this example, the first column is the AMP number. The second column contains a two-character code indicating whether the AMP is the primary ('P'), fallback ('F'), or both primary and fallback ('PF') AMP.

SELECT * FROM TABLE (ContiguousMapAmps('TD_Map1')) dt;

      AmpNo  AmpType
-----------  -------
          0  PF
          1  PF
          2  PF
          3  PF
          4  PF
          5  PF
          6  PF
          7  PF