If a named cache has only local configurations and objects bound to it, you cannot create a global cache configuration. You see error 19817. For example:
sp_cacheconfig 'SALES', '200M', 'instance SALES_INSTANCE' go sp_bindcache 'SALES','SALES_DB' go sp_cacheconfig 'SALES', '300m' go ------- Error 19817, "New configuration on cache 'SALES' is not permitted."
To avoid this situation in the example above, unbind all objects bound to cache “SALES”. Create a new configuration for cache “SALES”, and bind the objects again.
If you manually edit the configuration file to include multiple configurations of a named cache, and start the coordinator, the coordinator accepts only the configuration relevant to the coordinator’s instance. For example:
[Named Cache: Sales] [Instance:SALES_INSTANCE] cache size = 100 M cache status - mixed cache cache replacement policy = DEFAULT local cache partition number = 2 [Instance:HR_INSTANCE] cache size - 100M cache status = mixed cache cache replacement policy = DEFAULT
local cache partition number = 2
[2K I/O Buffer Pool] [Instance:SALES_INSTANCE] pool size = 100 M wash size = 4765 K local async prefetch limit = DEFAULT [Instance:HR_INSTANCE] pool size - 75M wash size = 3577 K local async prefetch limit = DEFAULT
After you start instance SALES_INSTANCE, the server can see only information about the SALES_INSTANCE configuration. The server ignores HR_INSTANCE.
WORKAROUND: To avoid this situation, add configuration information before starting instance HR_INSTANCE.