DB2 10.5 for Linux, UNIX, and Windows

CF self-tuning memory database configuration parameter

In a DB2® pureScale® environment, this read-only database configuration parameter indicates whether CF self-tuning memory is enabled or not.

Configuration type: Database
Parameter type: Informational
Default [range]: OFF [ON, OFF]

In the DB2 V10.5 FP5 and later releases, this read-only parameter is set ON when registry variable DB2_DATABASE_CF_MEMORY is set to AUTO, and, these database configuration parameters are set to AUTOMATIC: cf_gbp_sz, cf_lock_sz, and cf_sca_sz.

When set ON, CF self-tuning memory is enabled.