Purpose
Specifies the percentage limit for permanent, spool, and temporary space above the maximum value that the system permits for any database or user.
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 |