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.