17.10 - STATUS MAP - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

The STATUS MAP command reports the contiguous map configuration, including a list of the maps, their slots, and the AMP clusters defined by the maps.

Syntax

{ STATUS | ST } MAP

Example: Displaying the contiguous maps configuration

Enter a command, HELP or QUIT:
status map

SYSTEM NAME: localhost                                      17/03/17 14:03:37


                              MAP CONFIGURATION
                              -----------------

 Slot 0: TD_GlobalMap
  MAP State: Online

 Slot 1: TD_DataDictionaryMap
  MAP State: Online

 Slot 2: TD_Map1
  MAP State: Online

 Slot 3: TD_Map2
  MAP State: Online

         Slot 0   Slot 1   Slot 2   Slot 3
 AMP     Cluster  Cluster  Cluster  Cluster
 Number  No       No       No       No
 ------  -------  -------  -------  -------
     0        0        0        0        0
     1        0        0        0        0
     2        1        1        1        1
     3        1        1        1        1
------------------------------------------------------------------------------