17.10 - Example: Adjusting the Space Settings After a System Expansion - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Operators and User-Defined Functions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1210-171K
Language
English (United States)
The example database uses the following space values:
Amp No Allocated Perm Space Quota Perm Space Skew limit
0 800 1000 10
1 900 1000 10
2 1100 1000 10
3 1000 1000 10
The system is then expanded, adding two new AMPs. Each AMP has 1000 units of space and uses a 100% prorated distribution during the reconfiguration:
Amp No Allocated Perm Space Quota Perm Space Skew limit
0 800 1000 10
1 900 1000 10
2 1100 1000 10
3 1000 1000 10
4 0 1000 10
5 0 1000 10
After executing the AdjustSpace procedure for the database, the space values are changed:
Amp No Allocated Perm Space Quota Perm Space Skew limit
0 800 700 75
1 900 700 75
2 1100 700 75
3 1000 700 75
4 0 700 75
5 0 700 75