15.00 - ADD AMP - Teradata Database

Teradata Database Support Utilities

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

ADD AMP

Purpose  

The ADD AMP command adds an AMP or a range of AMPs to the new configuration map.

Syntax  

 

Syntax element …

Specifies …

mmmlist

the range of vproc numbers that is being added to the configuration.

AMP vprocs are numbered consecutively starting from 0 to a maximum number of 16199.

CN = nnnn

the cluster number with which the AMP is to be associated.

The cluster number ranges from 0 to 8099.

Usage Notes  

You can add an AMP or a range of AMPs to the Teradata Database in a well-defined order.

The AMP being added must have a vproc number equal to the number of AMPs currently entered in the new configuration map. That is, given a system with a new configuration map that describes n AMPs (whose vproc numbers are 0 through n-1), the only AMP that you can add to the system now is the AMP with vproc number n.

Configuration verifies that the vproc number specified for the new AMP does not exist in the new configuration map. When the ADD AMP command is accepted, the specified AMP is added to the vproc list, and the system displays:

The AMP is added.

If you type the ADD AMP command before the BEGIN CONFIG command, the command is ignored, and the system displays:

BEGIN CONFIG is not entered, and ADD AMP is ignored.

Example  

To add AMPs from vproc four to vproc seven in cluster three to the new configuration map, type:

add amps 4 - 7, cn = 3

Note: The maximum number of AMPs that you can add to a cluster is 8. To assign AMPs to clusters automatically, use “DEFAULT CLUSTER” on page 28.

Example  

To add an AMP as vproc eight in cluster three to the new configuration map, type:

add amp 8, cn = 3