You can display all or parts of the current Teradata system configuration by entering various Query Configuration options (also called key words). Enter help or a question mark (?) at the Query Configuration command prompt to see a list of the available options:
Enter display option, QUIT or END to terminate. > help The following key words return the indicated display. All; - complete configuration. Processors; - processor status. Online Processors; - online processors. Offline Processors; - offline processors. AMPs; - AMP status. Online AMPs; - online AMPs. Offline AMPs; - offline AMPs. PEs; - PE status. Online PEs; - online PEs. Offline PEs; - offline PEs.
The terminating semicolons are optional.
In a large Teradata system configuration, use discretion when selecting the All, AMPs, and Online AMPs options, because of the potentially large numbers of output lines that may be produced.
Instead of the All, AMPs, and Online AMPs options, consider Processor level options or the Offline AMPs and Offline PEs options when the configuration is large, to avoid having to deal with large numbers of Query Configuration output lines consuming valuable space and time resources.
ALL
To produce a display of all the components in the Teradata system and their current status, use the ALL option. The following is an example of an ALL display.
Enter display option, QUIT or END to terminate.
> all
all
DBS Configuration Status Report: 16/12/23 20:21:08
Global Global
Map Map
Vproc Node Config Config Cluster/ Vproc Node Config Config Cluster/
Number ID Type Status Host No. Number ID Type Status Host No.
------ ------- ---- -------- -------- ------ ------- ---- -------- --------
0 1-01 AMP Online 0 1 1-01 AMP Online 1
2 1-01 AMP Online 0 3 1-01 AMP Online 1
30718 1-01 PE Online 1 30719 1-01 PE Online 1
MAP Configuration
-----------------
Slot 0: TD_GlobalMap
MAP State: Online
Slot 1: TD_DataDictionaryMap
MAP State: Online
Slot 2: TD_Map1
MAP State: Online
Slot 0 Slot 1 Slot 2
AMP Cluster Cluster Cluster
Number No No No
------ ------- ------- -------
0 0 0 0
1 1 1 1
2 0 0 0
3 1 1 1
- The identifier (Node ID) of the Node associated with each vproc (virtual processor).
- The type (AMP or PE) of each vproc.
- The status (online or offline) of each vproc. A status of Online means that the associated Node is available and online to the operating system.
- The cluster (for an AMP) or host number (for a PE) associated with each vproc.
In addition, the output shows configuration information for the maps used for data distribution and indicates the fallback clustering defined by those maps.
Processors
To obtain configuration information for all processors in the Teradata system, use the Processors option. This option produces a display identical to that produced by the ALL option.
Online Processors or Offline Processors
Configuration information for all online or all offline processors that is similar to that of all processors is also available.
To obtain configuration information for online processors, use the Online Processors option. This option includes the same information as the all processors display option with the exception of the Status column. The following is an example of an Online Processors display.
Enter display option, QUIT or END to terminate.
online processors
DBS Configuration Status Report: 00/06/13 18:35:56
Global Global
Map Map
Vproc Node Config Cluster/ Vproc Node Config Cluster/
Number ID Type Host No. Number ID Type Host No.
------ ------- ---- -------- ------ ------- ---- --------
0 1-01 AMP 0 1 1-01 AMP 0
2 1-01 AMP 1 3 1-01 AMP 1
4 1-01 AMP 2 5 1-01 AMP 2
6 1-01 AMP 3 7 1-01 AMP 3
8 1-01 AMP 4 9 1-01 AMP 4
10 1-01 AMP 5 11 1-01 AMP 5
12 1-01 AMP 6 13 1-01 AMP 6
14 1-01 AMP 7 15 1-01 AMP 7
16 1-01 AMP 8 17 1-01 AMP 8
18 1-01 AMP 9 19 1-01 AMP 9
16380 1-01 PE 1 16381 1-01 PE 1
16382 1-01 PE 1 16383 1-01 PE 1
To obtain configuration information for offline processors, use the Offline Processors option. The information displayed is similar to that for all processors, but the Status column does not appear, since only offline processors are displayed.
AMPs
To obtain configuration information for all AMPs in the Teradata system, use the AMPs option. It produces a display containing AMP numbers, node identifiers, status (online or offline), and cluster numbers. The following is an example of an AMPs configuration display.
Enter display option, QUIT or END to terminate.
amps
DBS Configuration Status Report: 00/06/13 18:38:20
Global Global
Map Map
Vproc Node Config Config Cluster/ Vproc Node Config Config Cluster/
Number ID Type Status Host No. Number ID Type Status Host No.
------ ------- ---- -------- -------- ------ ------- ---- -------- --------
0 1-01 AMP Online 0 1 1-01 AMP Online 0
2 1-01 AMP Online 1 3 1-01 AMP Online 1
4 1-01 AMP Online 2 5 1-01 AMP Online 2
6 1-01 AMP Online 3 7 1-01 AMP Online 3
8 1-01 AMP Online 4 9 1-01 AMP Online 4
10 1-01 AMP Online 5 11 1-01 AMP Online 5
12 1-01 AMP Online 6 13 1-01 AMP Online 6
14 1-01 AMP Online 7 15 1-01 AMP Online 7
16 1-01 AMP Online 8 17 1-01 AMP Online 8
18 1-01 AMP Online 9 19 1-01 AMP Online 9
Online AMPS or Offline AMPs
The same type of configuration information previously described for all AMPs is also available for all online or all offline AMPs.
To obtain configuration information for online AMPs, use the Online AMPs option. The information displayed is similar to that for all AMPs, but the Status column does not appear, since only online AMPs are displayed.
To obtain configuration information for offline AMPs, use the Offline AMPs option. The information displayed is similar to that for all AMPs, but the Status column does not appear, since only offline AMPs are displayed.
PEs
To obtain configuration information for all PEs in the Teradata system, use the PEs option. It produces a display containing PE numbers, node identifiers, status (online or offline), and host numbers. The following is an example of a PEs configuration display.
Enter display option, QUIT or END to terminate.
pes
DBS Configuration Status Report: 00/06/13 18:44:20
Global Global
Map Map
Vproc Node Config Config Cluster/ Vproc Node Config Config Cluster/
Number ID Type Status Host No. Number ID Type Status Host No.
------ ------- ---- -------- -------- ------ ------- ---- -------- --------
16380 1-01 PE Online 1 16381 1-01 PE Online 1
16382 1-01 PE Online 1 16383 1-01 PE Online 1
Online PEs and Offline PEs
The same type of configuration information available as described for all PEs is also available for all online or all offline PEs.
To obtain configuration information for online PEs, use the Online PEs option. The information displayed is similar to that for all PEs, but the status is Online for each PE listed.
To obtain configuration information for offline PEs, use the Offline PEs option. The information displayed is similar to that for all PEs, but the status is Offline for each PE listed.