15.00 - Configuration Utility Examples - Teradata Database

Teradata Database Support Utilities

Teradata Database

Configuration Utility Examples

This section shows the process of adding vprocs to a Teradata Database.


Current configuration

New configuration

Four AMPS: 0, 1, 2, 3

Eight AMPS: 0, 1, 2, 3, 4, 5, 6, 7

Two PEs: 16383, 16382

Four PEs: 16383, 16382, 16381, 16380

Cluster 0: (0, 1, 2, 3)

Cluster 0: 0, 1, 4, 5

Cluster 1: 2, 3, 6, 7

Activities Performed

The configuration procedure described below performs three activities:

  • Adds AMPs
  • Adds PEs
  • Changes cluster assignments
  • For this demonstration, do the following in the Database window:

    1 In the Database Window, select the Supervisor (Supvr) icon.

    The Supervisor window appears.

    Note: The PDE must be up and the Supvr window must display the status as “Reading” before you can enter commands in the command input line.

    2 In the Enter a command subwindow of the Supervisor window, type the following and press Enter:

    start config

    The Supervisor window displays:

    Started ‘config’ in window 1.

    The window number represents the application window in which Configuration is running. The Configuration window appears.

    3 To begin the session, type the following in the Configuration window and press Enter:

    begin config

    4 To add AMPs numbered four through seven, type:

    add amp 4

    add amp 5

    add amp 6

    add amp 7

    5 To add PEs numbered 16381 and 16380 to host number one, type:

    add pe 16381, hn = 1

    add pe 16380, hn = 1

    6 To assign AMPs to clusters automatically, type:

    default cluster 4

    7 To end the session, type:

    end config

    8 To verify the new configuration, type:


    9 To stop configuration, type:


    You used Configuration to define the new system. Run the Reconfiguration utility next to configure the defined Teradata Database components into an operational system.

    For an example of how to run the Reconfiguration utility following the use of Configuration, see Support Utilities.