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.
- This value is computed as the module number within a cabinet plus the cabinet number times 10000. For example, a node #123 on cabinet #4 returns an INTEGER value of 40123.
- Status
- Status of the node associated with this record:
- U = Up/online
- D = Down/offline
- S = Standby
- A node is up (U) when the following are true:
- The node is configured into the system.
- The node is online.
- The node can perform tasks associated with normal database activity.
- Down (D) represents all other potential states.
- Standby (S) indicates the node is ready to join the configuration in place if another node goes down. When the node status is Standby, the SystemType, NetAUp, and NetBUp fields are not available and NULL or spaces are returned.
- 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'.
- 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'.
- 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.