Adjust Space Limits and Skew Settings | Teradata Vantage - Adjusting Space Limits and Skew Settings - Analytics Database - Teradata Vantage

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-03
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
Product Category
Teradata Vantage™
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.