The ADD AMP command adds an AMP or a range of AMPs to the new configuration map.
- 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.
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.
- 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
- 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.
To assign AMPs to clusters automatically, use DEFAULT CLUSTER.