15.10 - MonitorPhysicalConfig - Teradata Database

Teradata Database Application Programming Reference

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1090-151K

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

REPLACE FUNCTION SYSLIB.MonitorPhysicalConfig()
  RETURNS TABLE
   (ProcId      SMALLINT,
    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
   )
          .
          .
          .
;

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

 

Column Name

Description

ProcId

ID associated with a node. This value is computed as the module number within a cabinet plus 100 times the cabinet number. Usually formatted for display as zz9-99. However, this display format can be changed by the user.

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 Teradata 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 Teradata 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

    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.
  • 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.

    SELECT t2.* FROM TABLE (MonitorPhysicalConfig()) AS t2;
     
     *** Query completed. One row found. 9 columns returned.
     *** Total elapsed time was 1 second.
     
    ProcId Status CPUType CPUCount SystemType CliqueNo NetAUp NetBUp PhyMemory
    ------ ------ ------- -------- ---------- -------- ------ ------ ---------
        33 U      Xeon           1 5500C             0 U      U           5720