16.10 - LIST AMP - 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 AMP command displays the attributes of every AMP in the current or new configuration, or in a specified contiguous map.

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: Compact listing of AMP attributes

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   
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: Detailed listing of AMP attributes

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