Query Configuration Options - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-15
dita:mapPath
boh1556732696163.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantageā„¢

You can display all or parts of the current Teradata Database 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 Database 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 Database 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 information in the ALL display is ordered by vproc number. The display shows the following for each vproc:

  • 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 Database 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 Database 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 Database 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 above 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.