MonitorPhysicalConfigSV - Teradata VantageCloud Lake

Lake - Monitor Resources and Performance
Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
wyu1683671641248.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
wyu1683671641248

This single operational view API aggregates node availability data across VantageCloud Lake clusters.

Syntax

REPLACE FUNCTION SYSLIB.MonitorPhysicalConfigSV (
) RETURNS TABLE (
    ProcId INTEGER,
    Status CHAR CHARACTER SET LATIN,
    CPUType VARCHAR(7) CHARACTER SET LATIN,
    CPUCount SMALLINT,
    SystemType VARCHAR(7) CHARACTER SET LATIN,
    CliqueNo SMALLINT,
    NetAUp CHAR(1) CHARACTER SET LATIN,
    NetBUp CHAR(1) CHARACTER SET LATIN,
    PhyMemory INTEGER,
    Type VARCHAR,
    Id VARCHAR,
    Name VARCHAR,
    Group VARCHAR
  )
  ...
;

Syntax Elements

ProcId
ID associated with a node.
This value is incremented by 10000 for each group for the single view. The first node of the primary cluster starts at 10001, the first node of the first online compute cluster starts at 20001, and the first node of the second online compute cluster starts with 30001, and so on.
Status
Status of the node associated with this record:
  • U = Up/online
  • D = Down/offline
  • S = Standby
A node is up (U) when the following are true:
  • The node is configured into the system.
  • The node is online.
  • The node can perform tasks associated with normal database activity.
Down (D) represents all other potential states.
Standby (S) indicates the node is ready to join the configuration in place if another node goes down. When the node status is Standby, the SystemType, NetAUp, and NetBUp fields are not available and NULL or spaces are returned.
CPUType
Type of CPU installed in this node, for example: 'Pentium', 'PentPro', or 'Unknown'.
CPUCount
Number of CPUs in this node.
SystemType
Type of system running the database software, such as 5650, 6700, or 'Other'.
If all the nodes in the system are the same type, this field returns the type of the system.
If any of the nodes are of a different type, this field returns 'Mixed'.
CliqueNo
Clique number of the node.
NetAUp
NetBUp
Status of the BYNETs (if there are more than two, the first two) on a system-wide basis:
  • U = All node BYNETs are up/online.
  • D = One or more node BYNETs is down/offline.
  • "" = A temporary condition where the BYNET data is not available.
PhyMemory
Size of the physical memory of the node in MBs.
Type
Only available in the detailed view. Identifies the group type (compute cluster or primary cluster).
Id
Only available in the detailed view. Provides the TOS identifier the of the group (useful to identify compute clusters).
Name
Only available in the detailed view. Provides the name of the compute cluster.
Group
Only available in the detailed view. Provides the name of the compute group.