The Named Cache configuration parameter group provides details for named caches:
cache size - size of the cache. By default Adaptive Server 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 Adaptive Server for the change to take effect.
