15.00 - MPS_IncludePEOnlyNodes - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

MPS_IncludePEOnlyNodes

Purpose  

Excludes PE-only (AMP-less) nodes from MONITOR PHYSICAL SUMMARY Workload Management API statistics calculations.

Field Group

General

Valid Settings

 

Setting

Effect

TRUE

PE-only nodes are included in calculations.

FALSE

PE-only nodes are excluded from calculations.

Default

FALSE

Changes Take Effect

After the DBS Control Record has been written.

Related Topics

MONITOR PHYSICAL SUMMARY collects statistical system information which includes average, high, and low CPU and disk usage per node. It can be used to determine node-level system skew.

Some sites use PE-only nodes to aid in balancing the AMP workload. Because PE-only nodes are likely to experience substantially lower CPU and disk usage than nodes running AMPs, they can cause the node statistics to appear as if there is a data skew condition, when no such condition exists. In these cases, excluding PE-only nodes provides statistics that more accurately represent the true system workload conditions.

For more information about Teradata Database APIs, see Application Programming Reference.