Specifies the percentage of spool 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 spool 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||SQL Data Definition Language - Syntax and Examples.|
|related DBS Control fields|