Ajust Space Limits and Skew Settings | Teradata Vantage - 17.00 - 17.05 - About Adjusting Space Limits and Skew Settings - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval
After you have expanded your system, analyzed tables for map usage, and moved tables to other AMPs as needed, analyze whether space limits and skew settings need adjustment. Use the AdjustSpace procedure to adjust the permanent space quota and perm skew limit for one or more databases. This procedure adjusts the perm space quota to be as close as possible to current perm use while leaving some extra buffer space for future additions to the database. The following example adjusts space settings for all the databases in the system with the default buffer percentage:
CALL TDMaps.AdjustSpace(NULL, NULL, NULL, OutInfo);
This example sets the extra buffer space for the FINANCE database to 5%:
CALL TDMaps.AdjustSpace('FINANCE', 5, NULL, OutInfo);

TDMaps.SpaceSettingsTbl contains the default values for the AdjustSpace procedure, which a DBA can change as needed. The default buffer space is 10% and the rounding multiple for skew is 5%.

DBAs can use the AddDBInExcludeList macro to exclude databases that do not need space readjustments from the AdjustSpace procedure. The following example adds database SALES_DB to an exclusion list, so AdjustSpace skips SALES_DB when it is executing on all databases:
EXEC TDMaps.AddDBInExcludeList('SALES_DB');
DBAs can also use the DelDBInExcludeList macro to include a database previously excluded from the AdjustSpace procedure. The following example removes SALES_DB from an exclusion list so that it is not skipped when AdjustSpace is executing on all databases:
EXEC TDMaps.DelDBInExcludeList('SALES_DB');
You can use the AdjustSpace procedure on a system that has disabled global space accounting (the DBS Control utility flag LegacySpaceAcctg is set to TRUE). However, AdjustSpace will report an error if it tries to set a non-zero skew value for a system using legacy space accounting.

For more information, see Teradata Vantage™ - SQL Operators and User-Defined Functions, B035-1210.