If Adaptive Server cannot allocate all the memory requested, it allocates all the available memory and issues the following message:
ASE is unable to get all the memory requested (%d). (%d) kilobytes have been allocated dynamically.
However, this additional memory is not allocated until the next restart of Adaptive Server.
Adaptive Server notifies you of insufficient space is because some of the memory is unavailable because of resource constraints. System administrators should make sure these resource constraints are temporary. If the behavior persists, a subsequent restart may fail.
For example, if max memory is 700MB, pub_cache is
100MB, and the server’s total logical memory is
600MB, and you attempt to add 100MB to pub_cache, the
additional memory fits into max memory. However,
if the server can allocate only 90MB, then it allocates this amount
dynamically, but the size field of
the cache in the configuration file is updated to 100MB. On a subsequent
restart, since Adaptive Server obtains memory for all data caches at
one time, the size of pub_cache is
100MB.
