17.10 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

Use DBC.DiskSpaceErrorV to determine if any database has exceeded its maximum perm space or permissible skew limits. If so, you must manually adjust the maxperm space for those databases to prevent future database updates from exceeding the maximum and experiencing out of space errors.

Some applications (such as FastLoad, MultiLoad, and restore operations) may require more temporary space during processing.

Fields in DBS Control can be set to allow applications to exceed the maxperm space as long as there is physically enough disk space available. After the operation completes, reset the fields.