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:
|
| NetBUp | Status of the BYNETs (if there are more than two, the first two) on a system-wide basis:
|
| 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. |
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