16.10 - MPS_IncludePEOnlyNodes - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

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.