Example: Using AdjustSpace - Advanced SQL Engine - Teradata Database

SQL Operators and User-Defined Functions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2023-04-27
dita:mapPath
qqu1556127655717.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1210
lifecycle
previous
Product Category
Teradata Vantage™

To adjust space settings of all users and databases in the system (except DBC) with default settings, use:

CALL TDMaps.AdjustSpace(NULL, NULL, NULL, outlog);

To adjust space settings of a specific user or database with default settings, use:

CALL TDMaps.AdjustSpace('SALES_DB', NULL, NULL, outlog);

To adjust space settings of a specific user or database with a 10% buffer space percentage, use:

CALL TDMaps.AdjustSpace('SALES_DB', 10, NULL, outlog);

Using the ZeroSkewForSubMap Parameter

You can use the ZeroSkewForSubMap parameter when reconfiguring space for users in a system. For example, if you have a system with 100 AMPs that have 100 users in the system, you can reconfigure to add 100 more AMPs. You can then add the extra space to the users.

After reconfiguring, give the users the extra space by passing NULL as the DatabaseName parameter, which automatically releases the extra space and set based on how the data is skewed.

CALL TDMaps.AdjustSpace(NULL,NULL,'true',out1);