Specifies the percentage of temporary 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 temporary space.
This field should be changed only under the direction of Teradata Support Center personnel.
0 through 10000 percent
Changes Take Effect
After the DBS Control record has been written.
- For operations involving uniform load distribution across all the AMPs in the system, the default skew limit percentage may be set to lower values.
- If the system involves long running transactions with high space consumption, you can increase the value of the GlobalSpaceSoftLimitPercent DBS Control field to reduce the chances of transaction aborts due to a lack of available space.
|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|