Specifies the number of database pages allocated to the storage
area. The initial allocation never changes and is used for
the hash algorithm. The new allocation becomes the current
allocation. If you execute the RMU Dump/Header command, you see
the initial and the current allocation.
SQL automatically extends the allocation to handle the storage
requirements. Pages are allocated in groups of three (known as a
clump). An ALLOCATION of 25 pages actually provides for 27 pages
of data and subsequent expansion. The default is 700 pages.
The altered area is extended if the specified value exceeds
the current area allocation. Otherwise the specified value is
ignored.