16.10 - LIST PE - Teradata Database

Teradata Database Support Utilities

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

Purpose

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

Syntax



SHORT
Displays summarized information from the configuration or contiguous map. This is the default.
LONG
Displays detailed information from the configuration or contiguous map.
FROM or F
Use this to specify the map that contains the information you want to list:
  • CURRENT or C is the current configuration map. This is the default if you do not specify FROM or F.
  • NEW or N is the new configuration map, which will be in effect only after you run the Reconfiguration utility.
  • mapname or mapnumber identifies a contiguous map.

Example: Compact listing of PE attributes

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 

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: Detailed listing of PE attributes

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