DB2 10.5 for Linux, UNIX, and Windows
DB2 10.5 for Linux, UNIX, and Windows
This configuration parameter specifies the target duration (in seconds) for changed pages to be kept in the group buffer pool before the pages are persisted to disk or the caching facility. This parameter applies only to DB2® pureScale® instances.
The page_age_trgt_gcr parameter must be greater than or equal to page_age_trgt_mcr database configuration parameter.
The page_age_trgt_gcr parameter is used when the softmax parameter is configured to a value of 0. Migrated databases retain the previous value for softmax and ignore the page_age_trgt_gcr parameter if this value is not 0. The value of softmax is set to 0 in new databases.
Increasing the value of this configuration parameter keeps changed pages in memory for a longer time, allowing more page updates to be buffered before the pages are persisted to disk. This behavior can help to improve performance but also increases recovery time.