MonitorSystemPhysicalConfig

Teradata® Database Application Programming Reference

brand
Software
prodname
Teradata Database
vrm_release
16.20
category
Programming Reference
featnum
B035-1090-162K

Purpose

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

Definition

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
  )
          .
          .
          .
;

Usage Notes - MonitorSystemPhysicalConfig

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

Result Rows

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: Using MonitorSystemPhysicalConfig

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: Using MonitorSystemPhysicalConfig and Selecting a Specific Column

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