15.00 - MOVE AMP - Teradata Database

Teradata Database Support Utilities

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

MOVE AMP

Purpose  

The MOVE AMP command specifies that all data rows from an AMP or a group of AMPs are to be moved to another AMP or group of AMPs.

Syntax  

 

Syntax element …

Specifies …

mmmlist

the range of AMP vproc numbers being moved in the configuration.

nnnlist

the range of AMP vproc numbers that mmmlist is being moved to in the configuration.

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

Usage Notes  

The number of AMPs specified in mmmlist and in nnnlist must be the same. The following applies.

 

AMPs in the …

Must be …

mmmlist

AMPs defined in the current configuration.

nnnlist

new AMPs only.

After the MOVE AMP command is accepted, Configuration displays:

The AMP range is moved.

If you type the MOVE AMP command before the BEGIN CONFIG command, the command is ignored. Configuration displays:

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

If you type the MOVE AMP command and the ADD AMP command, and if the MOVE AMP range of vproc numbers is before the ADD AMP range of vproc numbers, Configuration displays:

Moved AMPS must follow added AMPs.

If you type the MOVE AMP command and either the MODIFY AMP command or the DEL AMP command, the commands are ignored. Configuration displays:

Addition, Deletion, and Moving of AMPS are mutually exclusive.
 

Note: Run the Reconfig utility to do the following:

  • Redistribute all rows from the moved AMPs
  • Change the configuration so that the moved AMPs are properly associated with the correct nodes and/or disk arrays
  • For more information on MOVE AMP and the Reconfiguration utility, see Utilities Volume 2.

    Example  

    To move AMP 0 in an existing eight-AMP system (AMPs 0-7) to a new AMP (AMP 8), type:

    move amp 0 to 8

    Example  

    To move AMPs 4-5 in an existing eight-AMP system (AMPs 0-7) to new AMPs (AMPs 8-9), type:

    move amp 4-5 to 8-9