15.00 - LIST AMP - Teradata Database

Teradata Database Support Utilities

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

LIST AMP

Purpose  

The LIST AMP command displays the attributes of every AMP in the current or new configuration map.

Syntax  

 

Syntax element …

Specifies …

SHORT

the compact configuration map of the AMP vprocs. This is the default.

This option contains only two fields:

  • vproc-id range
  • status
  • LONG

    the detailed configuration map of the AMP vprocs.

    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.

    The default map type is CURRENT. If you do not specify the map type, the AMP configuration is displayed from the current map.

    NEW

    the proposed configuration map.

    Usage Notes  

    The LIST AMP command displays the AMP configuration map.

    Example  

    An example output generated by the LIST AMP command is shown below:

    AMPs ARRAY
    ____________________________
       
    Vproc-Id Range    Status    Vproc-Id Range     Status
    ______________   _______    _______________    _______
       0-63           Online   

    Note: As indicated in the previous example, all the AMP vprocs are online, so the vproc-id is blocked from the beginning vproc 0 to the ending vproc 63. If the system displays AMP vprocs that have status other than online, the system lists their vproc-ids and status, as shown in the following example.

    AMPs ARRAY
    ____________________________
     
    Vproc-Id Range    Status    Vproc-Id Range     Status
    ______________   _______    _______________    _______
       0              Online      1-2              Fatal
       13-14          Online      15               Fatal 
       16-62          Online      63               NewReady

    Example  

    An example output generated by the LIST AMP LONG command is shown below:

    AMPs ARRAY
    ____________________________
      
    Vproc   Status   Cluster    Vproc   Status    Cluster
    _____   _______  _______    _____   _______   ________
       0    Online      0         1     Fatal        1
       2    Fatal       2         3     Online       3
       4    Online      4         5     Online       5
       .
       .
       .
       62   Online     14        63     Online      15