15.10 - MonitorPhysicalSummary - Teradata Database

Teradata Database Application Programming Reference

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1090-151K

Collects global summary information that includes the following types of information:

  • 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
  • REPLACE FUNCTION SYSLIB.MonitorPhysicalSummary()
          RETURNS TABLE
           (AvgCPU FLOAT, 
            AvgDisk FLOAT, 
            AvgDiskIO FLOAT, 
            HighCPUUse FLOAT, 
            HighDisk FLOAT, 
            HighDiskIO FLOAT, 
            HighCPUProcId SMALLINT,
            HighDiskProcId SMALLINT,
            HighDiskIOProcId SMALLINT,
            LowCPUUse FLOAT, 
            LowDisk FLOAT, 
            LowDiskIO FLOAT, 
            LowCPUProcId SMALLINT,
            LowDiskProcId SMALLINT,
            LowDiskIOProocId SMALLINT,
            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
           )
                   .
                   .
                   .
    ;

    The MonitorPhysicalSummary function provides similar functionality to the PMPC MONITOR PHYSICAL SUMMARY request. For information about this interface, see “MONITOR PHYSICAL SUMMARY” on page 103.

     

    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” on page 104 for details.

    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:

    (DiskUse1 + ... + DiskUsen) / n

    This value is NULL if certain conditions apply, see “Usage Notes” on page 104 for details.

    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:

    (DiskReads1 + DiskWrites1 + ... + DiskReads1 + DiskWritesn) / n

    This value is NULL if certain conditions apply, see “Usage Notes” on page 104 for details.

    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” on page 104 for details.

    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” on page 104 for details.

    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” on page 104 for details.

    HighCPUProcId

    ID of a node with CPPUse equal to the value reported as HighCPUUse.

    This value is NULL if certain conditions apply, see “Usage Notes” on page 104 for details.

    HighDiskProcId

    ID of a node with DiskUse equal to the value reported as HighDisk.

    This value is NULL if certain conditions apply, see “Usage Notes” on page 104 for details.

    HighDiskIOProcId

    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” on page 104 for details.

    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” on page 104 for details.

    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” on page 104 for details.

    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” on page 104 for details.

    LowCPUProcId

    ID of a node with CPPUse equal to the value reported as LowCPUUse.

    This value is NULL if certain conditions apply, see “Usage Notes” on page 104 for details.

    LowDiskProcId

    ID of a node with DiskUse equal to the value reported as LowDisk.

    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 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:

  • 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” on page 104 for details.

    Note: 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:

  • 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.
  • 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 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.

    SELECT * FROM TABLE (MonitorPhysicalSummary()) AS t1;
     
     *** Query completed. One row found. 22 columns returned.
     *** Total elapsed time was 1 second.
     
              AvgCPU   0.00000000000000E 000
             AvgDisk   3.66666666666667E 000
           AvgDiskIO   2.47300000000000E 003
          HighCPUUse   0.00000000000000E 000
            HighDisk   3.66666666666667E 000
          HighDiskIO   2.47300000000000E 003
       HighCPUProcId           33
      HighDiskProcId           33
    HighDiskIOProcId           33
           LowCPUUse   0.00000000000000E 000
             LowDisk   3.66666666666667E 000
           LowDiskIO   2.47300000000000E 003
        LowCPUProcId           33
       LowDiskProcId           33
    LowDiskIOProocId           33
              NetUse   0.00000000000000E 000
              NetAUp
              NetBUp
          ResLogging          600
          ResMonitor          600
          ReleaseNum   13.10.00.00
          Version      13.10.00.00