17.10 - STATUS PDE - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

The STATUS PDE command reports the status of the PDE.

Syntax

{ STATUS | ST } PDE

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.

Node Status Columns
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