The Adaptive Server data cache is managed on a most recently used/least recently used (MRU/LRU) basis. As pages in the cache age, they enter a wash area, where any dirty pages (pages that have been modified while in memory) are written to disk. There are some exceptions to this:
Caches configured with relaxed LRU replacement policy use the wash section as described above, but are not maintained on an MRU/LRU basis.
Typically, pages in the wash section are clean; that is, the I/O on these pages has been completed. When a task or query obtains a page from the LRU end, it expects the page to be clean. If not, the query must wait for the I/O to complete on the page, which impairs performance.
A special strategy ages out index pages and OAM pages more slowly than data pages. These pages are accessed frequently in certain applications and keeping them in cache can significantly reduce disk reads.
See Chapter 10, “Checking Database Consistency,” in System Administration Guide: Volume 2 for more information.
Adaptive Server may choose to use the LRU cache replacement strategy that does not flush other pages out of the cache with pages that are used only once for an entire query.
The checkpoint process ensures that, if Adaptive Server needs to be restarted, the recovery process can be completed in a reasonable period of time.
When the checkpoint process estimates that the number of changes to a database will take longer to recover than the configured value of the recovery interval configuration parameter, it traverses the cache, writing dirty pages to disk.
Recovery uses only the default data cache, making it faster.
The housekeeper wash task writes dirty pages to disk when idle time is available between user processes.