16.10 - STATUS PDE - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

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: Displaying the status of PDE

SYSTEM NAME: default_vconfig

                          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