The Named Cache configuration parameter group provides details for named caches.
cache size – size of the cache. By default SAP ASE creates 8MB caches. Change this parameter dynamically with sp_cacheconfig, or change the value in the server configuration file to have the change take place after the next server restart.
cache status – status of the cache. One of default data cache, log on ly, mixed, or in-memory storage. The default data cache must have a cache status of default data cache, and cannot be changed. cache status for named caches can be log only, mixed, or, for in-memory databases, in-memory storage (you cannot change the cache status for in-memory databases).
You cannot dynamically change the cache status in a clustered environment from log only on a local cache while other instance use a different cache status.
cache replacement – describes the cache replacement policy. For named caches and default data caches, the replacement policy is strict LRU or relaxed LRU. Change this parameter dynamically with sp_cacheconfig, or change the value in the server configuration file to have the change take place after the next server restart. The cache replacement policy must be none for in-memory databases because they do not use buffer or page replacement.
local cache partition number – number of cache partitions. You may partition a named cache into multiple cache partitions. The acceptable values are 0, 2, 4, 8, 16, 32, 64 or 128. You cannot change the number of cache partitions dynamically; you must restart SAP ASE for the change to take effect.