Adaptive Server 12.5.1 allows you to dynamically alter the data cache without having to restart the server, as was required in earlier versions. Using dynamic sp_cacheconfig actions, you release memory so that it can be reallocated immediately.
Some of the actions you can perform dynamically with sp_cacheconfig are:
Adding a new cache
Adding memory to an existing cache
Deleting a cache, either log or mix
Changing a cache type
If Adaptive Server cannot allocate all the memory requested, it allocates the available memory. The additional memory is allocated when you restart Adaptive Server.
Reducing cache size is not a dynamic action. Rather than using sp_cacheconfig to reduce cache size as a static action, remove the cache and recreate it with the correct size.
For more information, see the System Administration Guide.
