15.00 - Query Configuration Options - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

Query Configuration Options

You can display all or parts of the current Teradata Database system configuration by entering various Query Configuration options.

The following sections describe the options and their use:

  • ALL
  • Processors
  • Online processors
  • Offline processors
  • AMPs
  • Online AMPS
  • Offline AMPs
  • PEs
  • Online PEs
  • Offline PEs
  • 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 Option

    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
     
     
    DBS Configuration Status Report: 00/06/13 18:31:23 
     
     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   
     16380     1-01  PE   Online      1      16381     1-01  PE   Online      1   
     16382     1-01  PE   Online
     

    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.
  • Processors Option

    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” on page 778.

    Online Processors or Offline Processors Options

    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 
     
     Vproc    Node   Config Cluster/     Vproc    Node   Config Cluster/
     Number    ID     Type  HostId       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 Option

    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 
     
     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 Options

    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 Option

    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 
     
     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 Options

    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.

    Getting HELP

    To produce a list of all of the Query Configuration options, type HELP or question mark (?). The list of options appears as follows:

    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. 

    As indicated in the HELP option list, type a keyword to produce the desired display.