DefaultSpoolSkewLimitPercent - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-15
dita:mapPath
boh1556732696163.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantage™

Purpose

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.

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

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