16.20 - Example: Using 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)

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);