16.20 - AdjustSpace - 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)

Purpose

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.

Syntax



'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.