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.