16.10 - Configuration Maps - Teradata Database

Teradata Database Support Utilities

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Configuration
featnum
B035-1180-161K

Although the Configuration and Reconfiguration utilities are functionally independent, normally they are used together to change the configuration maps and contiguous maps.

A configuration map:

  • Stores the identification and status of each vproc in the Teradata Database
  • Identifies the AMPs that constitute each AMP cluster
  • Identifies each PE and its associated host

Each node contains its own copies of two types of configuration maps:

  • Current configuration maps (one for each contiguous map in the system), which describe the current arrangement and status of vprocs in the system
  • New configuration map (one only), which includes changes and additions to the configuration
Do not confuse configuration maps and contiguous maps:
  • Configuration maps are used by the Reconfiguration utility to change the system configuration, such as when new storage is added to or removed from the system with a consequent increase or decrease in the number of AMPs.
  • Contiguous maps define a contiguous range of AMPs. They are used by Teradata Database primarily to determine how to distribute the rows of a table among these AMPs, and can also be used to specify a limited range of AMPs on which certain table operators run.

The Configuration utility always creates a new configuration map. In most reconfiguration scenarios, the Configuration utility also creates a new contiguous map that takes into account a physical or logical change in the number of AMPs. But configuration maps and contiguous maps serve different purposes.

Before you can use the Config utility to list, delete, or show information about a vproc, you must add it to a configuration map.

If you want to add a vproc to the new configuration map, you must use the PUT utility to define the AMP or PE.

These component types constitute a Teradata Database configuration:

  • Hosts (or clients)
  • PE vprocs
  • AMP vprocs

For more information about PUT, see Parallel Upgrade Tool (PUT) Reference.

For more information about contiguous maps, see Database Design, Database Administration, and SQL Data Definition Language - Syntax and Examples.