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.
- BufferPercent
- he percentage of extra buffer space to retain in the database.
- 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.