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 |