MonitorPhysicalConfig Function | Application Programming Reference | Vantage - 17.10 - MonitorPhysicalConfig - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Application Programming Reference

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

Collects overall information on node availability. Node status information is returned for all nodes in the system.

Syntax

REPLACE FUNCTION SYSLIB.MonitorPhysicalConfig (
) 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
  )
  ...
;

Syntax Elements

ProcId
ID associated with a node.
This value is computed as the module number within a cabinet plus the cabinet number times 10000. For example, a node #123 on cabinet #4 would return an INTEGER value of 40123.
Status
Status of the node associated with this record:
  • U = Up/online
  • D = Down/offline
  • S = Standby
A node is up (U) when it is:
  • Configured into the system
  • Online
  • Capable of actively performing 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 will be 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.

Usage Notes

The MonitorPhysicalConfig function provides similar functionality to the PMPC MONITOR PHYSICAL CONFIG request. For information about this interface, see MONITOR PHYSICAL CONFIG.

Example: Using MonitorPhysicalConfig

SELECT t2.* FROM TABLE (MonitorPhysicalConfig()) AS t2;

 *** Query completed. One row found. 9 columns returned.
 *** Total elapsed time was 1 second.

    ProcId   10001
    Status  U
   CPUType  Xeon
  CPUCount       1
SystemType  5500C
  CliqueNo       0
    NetAUp
    NetBUp
 PhyMemory         5720