Purpose
Specifies the percentage of permanent space that an AMP is allowed to use over and above the per-AMP quota (the global maximum space limit divided by the number of AMPs). This is used for databases and users that are created without a SKEW option, or that are created with SKEW limit specified as DEFAULT for permanent space.
This field should be changed only under the direction of Teradata Support Center personnel.
Field Group
General
Valid Range
0 through 10000 percent
Default
0
Changes Take Effect
After the DBS Control record has been written.
Usage Notes
For operations involving uniform load distribution across all the AMPs in the system, the default skew limit percentage may be set to lower values.
Related Topics
| For more information on... | See... |
|---|---|
| the SKEW option for DDL, such as CREATE DATABASE and CREATE USER | Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144. |
| related DBS Control fields |