16.10 - ADD 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 ADD AMP command adds an AMP or a range of AMPs to the new configuration map.

Syntax



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.
AMP cluster assignments should be defined with respect to the hardware configuration. Usually, AMP failures result from hardware-related problems. AMP clustering assignments should be defined as closely as possible to the following fault-tolerant strategy:
  • For systems with a single cabinet containing all nodes, no two or more AMPs of a cluster reside in the same node.
  • For systems with multiple node cabinets, no two or more AMPs of a cluster reside in the same cabinet.
  • For systems with a single cabinet containing all disk arrays, no two or more AMPs of a cluster are serviced by the same disk array.
  • For systems with multiple cabinets of disk arrays, no two or more AMPs of a cluster are serviced by the same disk array cabinet.
  • For systems with more than one disk array controller, no two or more AMPs of a cluster are serviced by the same controller.

Example: Add an AMP to a cluster

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

add amp 8, cn = 3

Example: Add a range of AMPs to a cluster

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

add amps 4 - 7, cn = 3
A cluster must have a minimum of two AMPs.
  • For dedicated fallback, the cluster size can be increased up to eight AMPs, with each AMP having fallback on one other AMP.
  • For legacy fallback, the usual recommended cluster size is two AMPs, but some clusters may need to have more than two if there are an odd number of AMPs or if adding AMPs over time causes the cluster size to increase.
For more information on dedicated versus legacy fallback, see DUPLICATE MAP

To assign AMPs to clusters automatically, use DEFAULT CLUSTER.