16.10 - LIST CLUSTER - Teradata Database

Teradata Database Support Utilities

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Configuration
featnum
B035-1180-161K

Purpose

The LIST CLUSTER command displays the attributes of every AMP in the current or new configuration, or in a specified contiguous map, ordered by cluster number.

Syntax



SHORT
Displays summarized information from the configuration or contiguous map. This is the default.
LONG
Displays detailed information from the configuration or contiguous map.
FROM or F
Use this to specify the map that contains the information you want to list:
  • CURRENT or C is the current configuration map. This is the default if you do not specify FROM or F.
  • NEW or N is the new configuration map, which will be in effect only after you run the Reconfiguration utility.
  • mapname or mapnumber identifies a contiguous map.

Example: List AMP configuration attributes, ordered by cluster number

Example output generated by the LIST CLUSTER command is shown below:

AMPs ARRAY
_____________________
Vproc-Id Range  Status    CN     Vproc-Id Range  Status  Cluster
______________  _______ ________ _______________ ______  _______
0, 16, 32, 48   Online     0     1, 17, 33, 49    Online    1
2, 18, 34, 50   Online     2     3, 19, 35, 51    Online    3  
4, 20, 36, 54   Online     4     5, 21, 37, 53    Online    5
14, 30, 46, 62  Online    14    15, 31, 49, 63    Online   15
AMPs ARRAY
_____________________
Vproc      Status    Cluster    Vproc     Status    Cluster
______     ______    ________   _____     ______    _______
0          Online       0         1       Online      1
2          Online       2         3       Online      3  
4          Online       4         5       Online      5
62         Online       14        63      Online      15