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.
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.