Adaptive Server’s housekeeper wash task automatically begins cleaning dirty buffers during the server’s idle cycles. If the task is able to flush all active buffer pools in all configured caches, it wakes up the checkpoint process. This may result in faster checkpoints and shorter database recovery time.
System Administrators can use the housekeeper free write percent configuration parameter to tune or disable the housekeeper wash task. This parameter specifies the maximum percentage by which the housekeeper task can increase database writes.
For more information on tuning the housekeeper and the recovery interval, see “Recovery management” on page 99 in the book Performance and Tuning: Monitoring and Analyzing for Performance.
