15.10 - MonitorSystemPhysicalConfig - Teradata Database

Teradata Database Application Programming Reference

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

Returns BYNET status, system type and name values that are generated once for the whole system.

REPLACE FUNCTION SYSLIB.MonitorSystemPhysicalConfig()
  RETURNS TABLE
  (NetAUp      CHAR CHARACTER SET LATIN,
   NetBUp      CHAR CHARACTER SET LATIN,
   SystemType  VARCHAR(7) CHARACTER SET LATIN,
   SystemName  VARCHAR(15) CHARACTER SET LATIN
  )
          .
          .
          .
;

The MonitorSystemPhysicalConfig function provides similar functionality to statement 1 of the MONITOR PHYSICAL CONFIG request. For more information, see “MONITOR PHYSICAL CONFIG” on page 84.

 

Column Name

Description

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

    SystemName

    Name of the system running Teradata.

    Example  

    SELECT * FROM table (SYSLIB.MonitorSystemPhysicalConfig()) as t1;
     
     *** Query completed. One row found. 4 columns returned.
     *** Total elapsed time was 1 second.
     
    NetAUp  NetBUp  SystemType  SystemName
    ------  ------  ----------  ---------------
    U       U       5500C       localhost

    Example  

    SELECT SystemName FROM table (SYSLIB.MonitorSystemPhysicalConfig()) as t1;
     
     *** Query completed. One row found. One column returned.
     *** Total elapsed time was 1 second.
     
    SystemName
    ---------------.
    localhost