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.