MonitorPhysicalResourceSV - Teradata VantageCloud Lake

This single operational view API aggregates node-specific RSS data across VantageCloud Lake clusters.

Syntax

REPLACE FUNCTION SYSLIB.MonitorPhysicalResourceSV (
) RETURNS TABLE (
    ProcId INTEGER,
    Status CHAR CHARACTER SET LATIN,
    AmpCount SMALLINT,
    PECount SMALLINT,
    CPUUse FLOAT,
    PrcntKernel FLOAT,
    PrcntService FLOAT,
    PrcntUser FLOAT,
    DiskUse FLOAT,
    DiskReads FLOAT,
    DiskWrites FLOAT,
    DiskOutReqAvg FLOAT,
    NetAUse FLOAT,
    NetReads FLOAT,
    NetWrites FLOAT,
    HstBlkRd FLOAT,
    HstBlkWrts FLOAT,
    MemAllocates FLOAT,
    MemAllocateKB FLOAT,
    MemFailures FLOAT,
    MemAgings FLOAT,
    NetAUp CHAR(1) CHARACTER SET LATIN,
    NetBUp CHAR(1) CHARACTER SET LATIN,
    Type VARCHAR,
    Id VARCHAR,
    Name VARCHAR,
    Group VARCHAR
  )
  ...
;

Syntax Elements

ProcId

ID associated with a node.

This value is incremented by 10000 for each group for the single view. For example, the first node of the primary cluster starts at 10001, the first node of the first online compute cluster starts at 20001, and the first node of the second online compute cluster starts with 30001, and so on.

Status

Status of the node associated with this record:

• U = Up/online
• D = Down/offline

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.

AmpCount

Number of AMPs executing on the associated node.

PECount

Number of active PEs on the associated node.

CPUUse

% of CPU usage not spent being idle. The node-level display is computed from ResUsageSpma table data as PercntUser + PercntService. For information on ResUsageSpma table, see resusagespmaV.

This value is NULL if certain conditions apply.

PrcntKernel

% of CPU resources in idle and waiting for I/O completion. This value is computed from ResUsageSpma data as follows, where NCPUs is the number of CPUs:

((CPUIOWAIT/100) / (NCPUs * SampleSec)) * 100

This value is NULL if certain conditions apply.

For information on ResUsageSpma table, see resusagespmaV.

PrcntService

% of CPU resources spent in PDE user service processing. The value is computed from the ResUsageSpma table data, where x represents the number of CPUs:

CPUUServ / (x * SampleSec)

This value is NULL if certain conditions apply.

For information on ResUsageSpma table, see resusagespmaV.

PrcntUser

% of CPU resources spent in non-service user code processing. This value is computed from the ResUsageSpma table data, where x represents the number of CPUs:

CPUUExec / (x * SampleSec)

This value is NULL if certain conditions apply.

For information on ResUsageSpma, see resusagespmaV.

DiskUse

% of disk usage per node.

This value is computed from ResUsageSldv table data as follows, assuming n is the number of vdisks used by this AMP:

(LdvOutReqTime 1 + ... + LdvOutReqTime n) / (n*SampleSec)

The DiskUse field does not consider the overlapping of operations among multiple storage devices, but does allow for the possibility of multiple requests for the same device.

This value is NULL if certain conditions apply.

For information on ResUsageSldv, see resusagesldvV.

DiskReads

Total number of physical disk reads per node during the collection period. This value is computed from ResUsageSldv table data as follows, assuming n is the number of ldv devices used by this node:

LdvReads 1 + ... + LdvReads n

This value is NULL if certain conditions apply.

For information on ResUsageSldv, see resusagesldvV.

DiskWrites

Total number of physical disk writes per node during the collection period. This value is computed from ResUsageSldv table data as:

LdvWrites 1 + ... + LdvWrites n

This value is NULL if certain conditions apply.

For information on ResUsageSldv, see resusagesldvV.

DiskOutReqAvg

Average number of outstanding disk requests.

The value is computed from ResUsageSldv table data as follows, assuming n is the number of ldv controllers used by this node:

((LdvOutReqSum 1 / NULLIFZERO(LdvOutReqDiv 1)) + … + (LdvOutReqSum n / NULLIFZERO(LdvOutReqDiv n))) / n

The range of the value is typically 0 to 25.

This value is NULL if certain conditions apply.

For information on ResUsageSldv, see resusagesldvV.

NetAUse

% of BYNET A usage (actual BYNET receiver usage). (The BYNET transmitter usage is maintained in resource usage separately and is typically lower than the receiver usage. This is caused by multicasts, where one transmitter sends a message to multiple receivers.) This value is computed from the ResUsageSpma table data as:

((NetSamples - NetTxIdle) / NetSamples) * 100

This value is NULL if certain conditions apply.

For information on ResUsageSpma, see resusagespmaV.

NetReads

Number of Reads from the BYNET to the node. This value is computed from the ResUsageSpma table data as:

NetRxCircBrd + NetRxCircPtP

This value is NULL if certain conditions apply.

For information on ResUsageSpma, see resusagespmaV.

NetWrites

Number of messages written from the node to the BYNET during the collection period.

The value is computed from the ResUsageSpma table data as NetTxCircBrd + NetTxCircPtP.

This value is NULL if certain conditions apply.

For information on ResUsageSpma, see resusagespmaV.

HstBlkRds

Number of message blocks (one or more messages sent in one physical group) received from all clients.

This value is computed from ResUsageShst data, assuming n is the number of host channel and network connections on this node:

HostBlockReads 1 + ... + HostBlockReads n

This value is NULL if certain conditions apply.

For information on ResUsageShst, see resusageshstV.

HstBlkWrts

Number of message blocks (that is, one or more messages sent in one physical group) sent to all hosts.

This value is computed from ResUsageShst data, assuming n is the number of host channel and network connections on this node:

HostBlockWrites 1 + ... + HostBlockWrites n

This value is NULL if certain conditions apply.

For information on ResUsageShst, see resusageshstV.

MemAllocates

This column is deprecated and returns zero or NULL.

MemAllocateKB

Value represents the change in node-level memory. MemAllocateKB represents a delta from the previous reporting period, reporting negative values as less memory is used.

This value is calculated from the ResUsageSpma column MemVprAllocKB.

This value is NULL if certain conditions apply.

For information on ResUsageSpma, see resusagespmaV.

MemFailures

This column is deprecated and returns zero or NULL.

MemAgings

This column is deprecated and returns zero or NULL.

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.

Type

Only available in the detailed view. Identifies the group type (compute cluster or primary cluster).

Id

Only available in the detailed view. Identifies the id of the group (useful to identify compute clusters).

Name

Only available in the detailed view. Provides the name of the compute cluster.

Group

Only available in the detailed view. Provides the name of the compute group.

Usage Notes

MonitorPhysicalResourceSV returns the detailed resource usage information for each node. Because the function reports on each node, you can isolate performance concerns by node.