The following shows the format of a local named cache:
[Named Cache:log_sales] [Instance: SALES_INSTANCE] cache size = 100M cache status = mixed cache cache replacement policy = DEFAULT local cache partition number = DEFAULT
[2K I/O Buffer Pool] [Instance: SALES_INSTANCE] pool size = DEFAULT wash size = DEFAULT local async prefetch limit = DEFAULT
The global definition should be declared first in the configuration file, and then the local definition. The server does not start otherwise. An instance-specific pool configuration on a named cache, for example, is not permitted if there is no corresponding instance-specific cache configuration. The following example is illegal:
[Named Cache:tempdb_cache] cache size = 100M cache status = mixed cache cache replacement policy = DEFAULT local cache partition number = DEFAULT [2K I/O Buffer Pool] pool size = DEFAULT wash size = DEFAULT local async prefetch limit = DEFAULT [instance: SALES_INSTANCE] pool size = DEFAULT wash size = 40960K local async prefetch limit = DEFAULT
