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'.
- 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;
Result:
*** 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;
Result:
*** Query completed. One row found. One column returned. *** Total elapsed time was 1 second. SystemName --------------- localhost