page_age_trgt_gcr - Page age target group crash recovery configuration parameter
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 table space storage. This parameter applies only to Db2® pureScale® instances.
- Configuration type
- Database
- Parameter type
- Configurable Offline
- Default [range]
- 240 [1 - 65535]
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 kept in the group buffer pool before the pages are persisted to table space storage. This behavior can help to improve performance but also increases recovery time.