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