Collects overall information on node availability. Node status information is returned for all nodes in the system.
Syntax
REPLACE FUNCTION SYSLIB.MonitorPhysicalConfig ( ) RETURNS TABLE ( ProcId INTEGER, Status CHAR CHARACTER SET LATIN, CPUType VARCHAR(7) CHARACTER SET LATIN, CPUCount SMALLINT, SystemType VARCHAR(7) CHARACTER SET LATIN, CliqueNo SMALLINT, NetAUp CHAR(1) CHARACTER SET LATIN, NetBUp CHAR(1) CHARACTER SET LATIN, PhyMemory INTEGER ) ... ;
Syntax Elements
- ProcId
- ID associated with a node.
- Status
- Status of the node associated with this record:
- U = Up/online
- D = Down/offline
- S = Standby
- CPUType
- Type of CPU installed in this node, for example: 'Pentium', 'PentPro', or 'Unknown'.
- CPUCount
- Number of CPUs in this node.
- SystemType
- Type of system running the database software, such as 5650, 6700, or 'Other'.
- CliqueNo
- Clique number of the node.
- 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.
- PhyMemory
- Size of the physical memory of the node in MBs.
Usage Notes
The MonitorPhysicalConfig function provides similar functionality to the PMPC MONITOR PHYSICAL CONFIG request. For information about this interface, see MONITOR PHYSICAL CONFIG.
Example: Using MonitorPhysicalConfig
SELECT t2.* FROM TABLE (MonitorPhysicalConfig()) AS t2; *** Query completed. One row found. 9 columns returned. *** Total elapsed time was 1 second. ProcId 10001 Status U CPUType Xeon CPUCount 1 SystemType 5500C CliqueNo 0 NetAUp NetBUp PhyMemory 5720