AdjustSpace | SQL Operators & User-Defined Functions | Teradata Vantage - 17.10 - AdjustSpace - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Operators and User-Defined Functions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1210-171K
Language
English (United States)

After moving tables to maps or expanding a system, the database space limits may no longer be accurate or reflect the actual space usages. Use the AdjustSpace procedure to re-adjust the space and skew values for a user or database.

ANSI Compliance

This statement is a Teradata extension to the ANSI SQL:2011 standard.

Syntax

CALL [TDMaps.] AdjustSpace (
  'DatabaseName',
  'BufferPercent',
  'ZeroSkewForSubMap',
  'OutInfo'
)

Syntax Elements

DatabaseName
The name of the database with the maximum permanent space and permanent skew to adjust based on its current usage.
If ‘NULL,’ all databases in the system are considered for adjustment, except for the databases listed in TDMaps.SpaceExcludeDBListTbl.
BufferPercent
he percentage of extra buffer space to retain in the database.
If NULL, the default values is fetched from TDMaps.SpaSettingsTbl.
ZeroSkewForSubmap
Sets zero skew if all the tables are in same map, and that map is a subset of TD_GLOBALMAP. Valid values are true, false, t, f, and NULL.
OutInfo
Returns success or failure information. Additional output is logged into TDMaps.SpaceLogTbl.