SQL$HELP72.HLB  —  ALTER  DATABASE  Arguments  ALLOCATION IS n PAGES
    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.
Close Help