16.20 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Operators and User-Defined Functions

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
April 2020
Content Type
Administration
Programming Reference
Publication ID
B035-1210-162K
Language
English (United States)

The AdjustSpace procedure re-adjusts both the maximum permanent space and skew limit values of one or more databases. The re-adjustment is based on the database's current space usage and data distribution across AMPs.

Use the AdjustSpace procedure for users or databases after a system expansion, when the maximum space limits are increased. After analyzing all of the underlying tables within the user or database for map usage and altering them as recommended, use AdjustSpace to adjust the space and skew settings.

The permanent space quota is modified to be as near as possible to its current permanent space usage leaving some extra buffer space. The new permanent space quota is adjusted to a nearest multiple of default space chunk size.

After executing the procedure, the space columns (perm quota, current perm, allocated perm and perm skew) of the database before and after modification is recorded in TDMaps.SpaceLogTable.

Databases with 0 as the current space are not modified by this procedure.

An error is reported if the DBS control flag LegacySpaceAcctg is set to TRUE, because setting a skew to non-zero value is not permitted with that setting.