16.10 - GlobalSpaceSoftLimitPercent - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

Purpose

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 Topics

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