15.00 - LIST PE - Teradata Database

Teradata Database Support Utilities

prodname
Teradata Database
vrm_release
15.00
category
Configuration
featnum
B035-1180-015K

LIST PE

Purpose  

The LIST PE command displays the attributes of every PE in the current or new configuration map.

Syntax  

 

Syntax element …

Specifies …

SHORT

the compact configuration map of the PE vprocs. This is the default.

This option contains only two fields:

  • vproc-id range
  • status
  • LONG

    the detailed configuration map of the PE vprocs.

    This option contains three fields:

  • vproc
  • status
  • hostno
  • FROM

    that you will choose the type of configuration map to be displayed.

    CURRENT

    the configuration map that the Teradata Database is using currently. This is the default.

    If you do not specify the map type, the current PE configuration map is displayed.

    NEW

    the proposed configuration map.

    Usage Notes  

    The LIST PE command displays the PE configuration map.

    Example  

    An example output generated by the LIST PE command is shown below.

    PEs ARRAY
    _________________________
     
    Vproc-Id Range    Status       Vproc-Id Range    Status 
    _______________   _______      _______________   _______
    16343-16383       Online 

    Note: As indicated in the previous example, all the PE vprocs are online, so the vproc-id is blocked from the beginning vproc 16343 to the ending vproc 16383. If the system displays PE vprocs that have status other than online, the system lists their vproc-id and status, as shown in the following example.

    PEs ARRAY
    _________________________
     
    Vproc-Id Range    Status        Vproc-ID Range     Status 
    _______________   _______       ______________     _______
    16343-16354       Online        16355              Down 
    16356-16363       Online        16364              Down
    16365-16377       Online        16378              Down
    16379-16383       Online

    Example  

    An example output generated by the LIST PE LONG command is shown below.

    PEs ARRAY
    _________________________
    Vproc     Status     HostNo       Vproc     Status     HostNo  
    ______    _______    _______      ______    ______     _______
    16344     Online     282          16345     Online     282  
    16346     Online     282          16347     Online     282
    16348     Online     282          16349     Online     282
    .
    .
    .
    16382     Online      52          16383     Online     282