STATUS MAP - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
xha1591998860283.ditamap
dita:ditavalPath
xha1591998860283.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantageā„¢

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
------------------------------------------------------------------------------