15.00 - LIST CLUSTER - Teradata Database

Teradata Database Support Utilities

prodname
Teradata Database
vrm_release
15.00
category
Configuration
featnum
B035-1180-015K

LIST CLUSTER

Purpose  

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

Usage Notes  

 

Syntax element …

Specifies …

SHORT

the compact display of the attributes of every AMP in the current or new configuration map, ordered by cluster number.

This option contains three fields:

  • vproc-id range
  • status
  • CN
  • This is the default.

    LONG

    the detailed display of the attributes of every AMP in the current or new configuration map, ordered by cluster number.

    This option contains three fields:

  • vproc
  • status
  • cluster
  • FROM

    that you will choose the type of configuration map to be displayed.

    CURRENT

    the configuration map that the Teradata Database is using currently. This is the default.

    If you do not specify a map type, the current configuration map is displayed.

    NEW

    the proposed configuration map.

    Usage Notes  

    The LIST CLUSTER command displays the cluster configuration map. This map shows a list of AMPs ordered by cluster number.

    Example  

    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