MonitorSystemPhysicalConfig | Application Programming Reference | Vantage - 17.10 - MonitorSystemPhysicalConfig - 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)

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

Syntax

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

Syntax Elements

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.
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'.
SystemName
Name of the system running Teradata.

Usage Notes

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

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