Configuring caches

Named data caches are created with the new system procedure sp_cacheconfig. Memory pools for large I/O are configured within data caches with sp_poolconfig. Configuring caches and pools can also be done by editing a configuration file.

Entities are bound to caches with sp_bindcache and unbound with sp_unbindcache or sp_unbindcache_all. The system procedure sp_helpcache provides information about caches and cache bindings. sp_cacheconfig also provides information about caches and the pools within caches.

See Chapter 9, “Configuring Data Caches,” in the System Administration Guide for instructions on configuring named caches and binding database objects to them.