Use sp_cacheconfig to add memory to an existing cache.
The additional memory you allocate is added to the Adaptive Server page size pool. For example, in a server with a logical page size of 4K, the smallest size for a pool is a 4K buffer pool. If the cache has partitions, additional memory is divided equally among them.
If there is insufficient memory available, Adaptive Server allocates what it can, then allocates the full amount when you restart the server. See “Insufficient space for new cache”.
For example, to add 2MB to a cache named pub_cache (the current size is 10MB), enter:
sp_cacheconfig pub_cache, “12M”
After you add the memory, sp_cacheconfig output is:
sp_cacheconfig pub_cache
Cache Name Status Type Config Value Run Value ------------------------------ --------- -------- ------------ ------------ pub_cache Active Mixed 12.00 Mb 12.00 ------------ ------------ Total 12.00 Mb 12.00 Mb ========================================================================== Cache: pub_cache, Status: Active, Type: Mixed Config Size: 12.00 Mb, Run Size: 12.00 Mb Config Replacement: strict LRU, Run Replacement: strict LRU Config Partition: 1, Run Partition: 1 IO Size Wash Size Config Size Run Size APF Percent -------- --------- ------------ ------------ ----------- 4 Kb 2456 Kb 0.00 Mb 12.00 Mb 10
The change adds memory to the database page-size buffer pool and recalculates the wash size, as required. If the absolute value is set for wash size, Adaptive Server does not recalculate it.
