MonitorPhysicalSummary Syntax Elements - Teradata Vantage
Teradata® VantageCloud Lake
- Deployment
- VantageCloud
- Edition
- Lake
- Product
- Teradata Vantage
- Published
- January 2023
- ft:locale
- en-US
- ft:lastEdition
- 2024-12-11
- dita:mapPath
- phg1621910019905.ditamap
- dita:ditavalPath
- pny1626732985837.ditaval
- dita:id
- phg1621910019905
- AvgCPU
- Average % CPU usage (CPUUse) time of all online nodes in the database configuration.
- This value is NULL if certain conditions apply, see usage notes.
- AvgDisk
- Average % disk usage (from DiskUse) of all online nodes in the 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.
- 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.
- HighCPUUse
- Highest CPUUse number associated with any online node that is part of the database configuration.
- This value is NULL if certain conditions apply, see usage notes.
- HighDisk
- Highest % disk usage (from DiskUse) associated with any online node that is part of the database configuration.
- This value is NULL if certain conditions apply, see usage notes.
- 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.
- 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 returns an INTEGER value of 40123.
- This value is NULL if certain conditions apply, see usage notes.
- 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 returns an INTEGER value of 40123.
- This value is NULL if certain conditions apply, see usage notes.
- 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 returns an INTEGER value of 40123.
- This value is NULL if certain conditions apply, see usage notes.
- LowCPUUse
- Lowest CPUUse number associated with any online node that is part of the database configuration.
- This value is NULL if certain conditions apply, see usage notes.
- LowDisk
- Lowest % disk usage (from DiskUse) associated with any online node that is part of the database configuration.
- This value is NULL if certain conditions apply, see usage notes.
- LowDiskIO
- Lowest DiskReads and DiskWrites number associated with any online node that is part of the database configuration.
- This value is NULL if certain conditions apply, see usage notes.
- 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 returns an INTEGER value of 40123.
- This value is NULL if certain conditions apply, see usage notes.
- 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 returns an INTEGER value of 40123.
- This value is NULL if certain conditions apply, see usage notes.
- 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 returns an INTEGER value of 40123.
- This value is NULL if certain conditions apply, see usage notes.
- 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:
- NetCount is 2 if both NetA and NetB are up or 1 if only one of the BYNET is up.
- Average NetAUse is the sum of all NetAUse of each node divided by the number of online nodes.
- This value is NULL if certain conditions apply, see usage notes.
- NetUse returns a value of zero because resource usage data is not available.
- 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.
- 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 using the PM/API.
- ReleaseNum
- Release number of the running database software (for example, 15.00.00.00).
- This value is supplied by the database.
- Version
- Version number of the running database software (for example, 15.00.00.00).
- This value is supplied by the database.