17.10 - GlobalSpaceSoftLimitPercent - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

Specifies the percentage limit for permanent, spool, and temporary space above the maximum value that the system permits for any database or user.

This field should be changed only under the direction of Teradata Support Center personnel.

Field Group

General

Valid Range

0 through 100 percent

Default

0

Changes Take Effect

After the DBS Control record has been written.

Usage Notes

If the system involves long running transactions with high space consumption, you can increase the value of GlobalSpaceSoftLimitPercent to reduce the chances of transaction aborts due to a lack of available space.

Teradata recommends setting a non-zero soft limit, because that provides flexibility to modify limits without impacting data load applications that may otherwise report out-of-space errors.

The DBC space limit should be ample enough that there is enough soft limit cushion to handle the extra space usage without hitting space errors unexpectedly. For example, assume the soft limit is set to 10% system-wide. The DBA can ensure that the available space in DBC is around 10% using this setting.

Related Information

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