Usage Notes - Advanced SQL Engine - Teradata Database

SQL Operators and User-Defined Functions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2023-04-27
dita:mapPath
qqu1556127655717.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1210
lifecycle
previous
Product Category
Teradata Vantage™

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.