The AdjustSpace procedure adjusts the maximum permanent space and skew limit values of one or more databases. The adjustment is based on the database current space usage and data distribution across AMPs.
Use the AdjustSpace procedure for users or databases after a system expansion, when the maximum space limits are increased. After altering the underlying tables within the user or database for map usage as recommended, use AdjustSpace to adjust the space and skew settings.
The permanent space quota is modified to be close to its current permanent space usage, leaving extra buffer space. The new permanent space quota is adjusted to a nearest multiple of default space chunk size.
After running the procedure, the space columns (perm quota, current perm, allocated perm and perm skew) of the database before and after modification is recorded in TDMaps.SpaceLogTable.
Databases with 0 as the current space are not modified by this procedure.