15.00 - STATUS PDE - 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

STATUS PDE

Purpose  

The STATUS PDE command reports the status of the PDE.

Syntax  

Usage Notes  

The STATUS PDE command returns the PDE Status Table only. The PDE Status Table includes a status row for each node that is defined on the system. The columns of the node status row are shown in the following table.

 

Column

Description

Node ID

The Node ID as defined using the Parallel Upgrade Tool (PUT). For more information, see the Parallel Upgrade Tool (PUT) Reference. The Node ID is formatted as CCC-MM, where CCC denotes the cabinet number and MM denotes the module number.

Node State

The current state of the node, which is either ONLINE, DOWN, or STANDBY.

Clique Number

The clique number for the node as defined using the Parallel Upgrade Tool (PUT). For more information, see the Parallel Upgrade Tool (PUT) Reference.

CPUs

The number of CPUs on the node.

Memory (MB)

The total memory size in megabytes for the node (rounded up to the nearest integer).

CHANs

The number of channels attached to the node.

LANs

The number of LANs attached to the node.

AMPs

The number of AMPs running on the node.

Node Name

The network name for the node.

Example  

SYSTEM NAME: default_vconfig                                03/01/21 13:35:49
 
                          PDE PHYSICAL CONFIGURATION
                          --------------------------
 
Node    Node    Clique      Memory         
ID      State   Number CPUs  (MB)  CHANs LANs AMPs Node Name
------- ------- ------ ---- ------ ----- ---- ---- --------------------------------
  4-06  ONLINE     0     4   2043    0     1    4  puthod1_bynet 
  4-07  ONLINE     0     2   2043    0     1    4  puthod2_bynet 
  4-08  ONLINE     0     2   2043    0     1    4  puthod3_bynet 
------------------------------------------------------------------------------
 
Node    Node    Clique      Memory         
ID      State   Number CPUs  (MB)  CHANs LANs AMPs Node Name
------- ------- ------ ---- ------ ----- ---- ---- --------------------------------
  4-09^ STANDBY    0     0      0    0     1    4  puthod4_bynet
------------------------------------------------------------------------------
^ Non-TPA Node
  PDE State: RUN/STARTED