How memory is allocated

Prior to version 12.5 of Adaptive Server, the size of the procedure cache was based on a percentage of the available memory. After you configured the data cache, whatever was left over was allocated to the procedure cache. For Adaptive Server 12.5 and later, the data cache and the procedure cache are specified as absolute values. The sizes of the caches do not change until you reconfigure them.

Use the configuration parameter max memory to establish a maximum setting, beyond which you cannot configure Adaptive Server’s total physical memory.