Purpose
- CPU usage (average, high, and low)
- Disk usage (average, high, and low)
- BYNET usage (total, up/down)
- Rate information (resource logging rate and resource monitoring rate)
- Current software release and version numbers
Definition
REPLACE FUNCTION SYSLIB.MonitorPhysicalSummary() RETURNS TABLE (AvgCPU FLOAT, AvgDisk FLOAT, AvgDiskIO FLOAT, HighCPUUse FLOAT, HighDisk FLOAT, HighDiskIO FLOAT, HighCPUProcId INTEGER, HighDiskProcId INTEGER, HighDiskIOProcId INTEGER, LowCPUUse FLOAT, LowDisk FLOAT, LowDiskIO FLOAT, LowCPUProcId INTEGER, LowDiskProcId INTEGER, LowDiskIOProocId INTEGER, NetUse FLOAT, NetAUp CHAR(1)CHARACTER SET LATIN, NetBUp CHAR(1)CHARACTER SET LATIN, ResLogging SMALLINT, ResMonitor SMALLINT, ReleaseNum VARCHAR(30)CHARACTER SET LATIN, Version VARCHAR(32) CHARACTER SET LATIN ) . . . ;
Usage Notes - MonitorPhysicalSummary
The MonitorPhysicalSummary function provides similar functionality to the PMPC MONITOR PHYSICAL SUMMARY request. For information about this interface, see MONITOR PHYSICAL SUMMARY.
Result Rows
Column Name | Description |
---|---|
AvgCPU | Average % CPU usage (CPUUse) time of all online nodes currently in the Teradata Database configuration. This value is NULL if certain conditions apply, see Usage Notes - MONITOR PHYSICAL SUMMARY. |
AvgDisk | Average % disk usage (from DiskUse) of all online nodes currently in the Teradata Database configuration. Assuming n is the number of online AMPs in the configuration, AMPAvgDisk is computed from DiskUse data as: (DiskUse 1+ ... + DiskUse n ) / n This value is NULL if certain conditions apply, see Usage Notes - MONITOR PHYSICAL SUMMARY. |
AvgDiskIO | Average physical disk DiskReads and DiskWrites of all online AMPs in the configuration. Assuming n is the number of online AMPs in the configuration, AMPAvgDiskIO is computed from DiskReads and DiskWrites data as: (DiskReads 1+ DiskWrites 1+ ... + DiskReads 1+ DiskWrites n ) / n This value is NULL if certain conditions apply, see Usage Notes - MONITOR PHYSICAL SUMMARY. |
HighCPUUse | Highest CPUUse number associated with any online node that is currently part of the Teradata Database configuration. This value is NULL if certain conditions apply, see Usage Notes - MONITOR PHYSICAL SUMMARY. |
HighDisk | Highest % disk usage (from DiskUse) associated with any online node that is currently part of the Teradata Database configuration. This value is NULL if certain conditions apply, see Usage Notes - MONITOR PHYSICAL SUMMARY. |
HighDiskIO | ID of a node with DiskReads and DiskWrites equal to the value reported as HighDiskIO. This value is NULL if certain conditions apply, see Usage Notes - MONITOR PHYSICAL SUMMARY. |
HighCPUProcId | ID of a node with CPPUse equal to the value reported as HighCPUUse. 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 would return an INTEGER value of 40123. This value is NULL if certain conditions apply, see Usage Notes - MONITOR PHYSICAL SUMMARY. |
HighDiskProcId | ID of a node with DiskUse equal to the value reported as HighDisk. 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 would return an INTEGER value of 40123. This value is NULL if certain conditions apply, see Usage Notes - MONITOR PHYSICAL SUMMARY. |
HighDiskIOProcId | ID of a node with DiskReads and DiskWrites equal to the value reported as HighDiskIO. 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 would return an INTEGER value of 40123. This value is NULL if certain conditions apply, see Usage Notes - MONITOR PHYSICAL SUMMARY. |
LowCPUUse | Lowest CPUUse number associated with any online node that is currently part of the Teradata Database configuration. This value is NULL if certain conditions apply, see Usage Notes - MONITOR PHYSICAL SUMMARY. |
LowDisk | Lowest % disk usage (from DiskUse) associated with any online node that is currently part of the Teradata Database configuration. This value is NULL if certain conditions apply, see Usage Notes - MONITOR PHYSICAL SUMMARY. |
LowDiskIO | Lowest DiskReads and DiskWrites number associated with any online node that is currently part of the Teradata Database configuration. This value is NULL if certain conditions apply, see Usage Notes - MONITOR PHYSICAL SUMMARY. |
LowCPUProcId | ID of a node with CPPUse equal to the value reported as LowCPUUse. 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 would return an INTEGER value of 40123. This value is NULL if certain conditions apply, see Usage Notes - MONITOR PHYSICAL SUMMARY. |
LowDiskProcId | ID of a node with DiskUse equal to the value reported as LowDisk. 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 would return an INTEGER value of 40123. This value is NULL when LowDisk is NULL. |
LowDiskIOProocId | ID of a node with DiskReads and DiskWrites equal to the value reported as LowDiskIO. 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 would return an INTEGER value of 40123. This value is NULL when LowDiskIO is NULL. |
NetUse | % of total BYNET use (that is, average of the online BYNETs). If both BYNETs are up, the value is computed from ResUsageSpma table data as: NetUse = Average NetAUse per node / NetCount where:
This value is NULL if certain conditions apply, see Usage Notes - MONITOR PHYSICAL SUMMARY. NetUse returns a value of zero because resource usage data is not currently available.
|
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:
|
ResLogging | Interval in seconds at which resource usage data is written to one or more active resource usage database tables. |
ResMonitor | Interval in seconds at which all resource usage data is collected in memory for reporting via the PM/API. |
ReleaseNum | Release number of the currently running Teradata Database software (for example, 15.00.00.00). This value is supplied by Teradata Database. |
Version | Version number of the currently running Teradata Database software (for example, 15.00.00.00). This value is supplied by Teradata Database. |
Example: Using MonitorPhysicalSummary
SELECT * FROM TABLE (MonitorPhysicalSummary()) AS t1; *** Query completed. One row found. 22 columns returned. *** Total elapsed time was 1 second. AvgCPU 1.00000000000000E 002 AvgDisk 7.51986754966887E 000 AvgDiskIO 6.64700000000000E 003 HighCPUUse 1.00000000000000E 002 HighDisk 7.51986754966887E 000 HighDiskIO 6.64700000000000E 003 HighCPUProcId 10001 HighDiskProcId 10001 HighDiskIOProcId 10001 LowCPUUse 1.00000000000000E 002 LowDisk 7.51986754966887E 000 LowDiskIO 6.64700000000000E 003 LowCPUProcId 10001 LowDiskProcId 10001 LowDiskIOProcId 10001 NetUse 0.00000000000000E 000 NetAUp U NetBUp U ResLogging 60 ResMonitor 60 ReleaseNum 16t.00.00.97 Version 16t.00.00.97_dr182707k