Parameters in this group specify properties in a named cache. Each configured data cache on the server has this block of information in the configuration file. In this case, this group contains the configuration file entries for a separate default data cache.
[Named Cache:default data cache] cache size = 1700M cache status = default data cache cache replacement policy = DEFAULT local cache partition number = 4
cache size = 1700M The value of 1700M is a starting point for the RAP sample database. The remainder of the 1700M goes to the 4K buffer pool. When changing cache size, give the least to the 16K pool. This option is tunable and can be increased to improve the speed of queries.
cache status = default data cache This named cache is the default data cache.
local cache partition number = 4 The value of 4 is for a four-CPU machine. This value can be greater for a greater number of CPUs. Increasing the number of cache partitions for a cache can reduce spinlock contention and improve performance.
[4K I/O Buffer Pool] pool size = DEFAULT wash size = DEFAULT local async prefetch limit = DEFAULT
[16K I/O Buffer Pool] pool size = 100M wash size = DEFAULT local async prefetch limit = DEFAULT
pool size = 100M To avoid using a large buffer pool and to have fewer large I/Os, the value of 100M for buffer pool size is relatively small. The remainder of the 1700M is allocated to the 4K buffer pool. When changing cache size, allocate the least amount to the 16K pool.
