Db2 pureScale Feature configuration parameters
For the IBM® Db2 pureScale Feature, there are several configuration parameters to support members and the cluster caching facility, also known as CF. These database configuration parameters are divided into global and per-member parameters.
Db2 pureScale Feature database manager configuration parameters
The following table lists the database manager configuration parameters for the cluster caching facility. The database manager configuration parameters apply to instance level configuration.
| Parameter name | Details |
|---|---|
| cf_diaglevel | Specifies the level of diagnostic errors that are recorded in the cfdiag.log file. |
| cf_diagpath | Specifies the directory that contains the CF diagnostic log file that are generated based on the value of the cf_diaglevel parameter. |
| cf_mem_sz | Determines the total memory used by the CF. The value must be less than the amount of physical memory on the CF host. |
| cf_num_conns | Determines the initial size of the CF connection pool. |
| cf_num_workers | Determines how many worker threads are started by the CF server. The value is typically less than or equal to the number of CPUs on the CF server. |
| cf_transport_method | Controls what method is used for communication between Db2 members and the CF. |
Db2 pureScale Feature database configuration parameters
| Parameter name | Details |
|---|---|
| cf_catchup_trgt | Determines the target time in minutes for completing the catch up to bring a newly added or newly restarted CF into peer state with an existing primary CF. |
| cf_db_mem_sz | Determines the total CF memory limit for the current database. |
| cf_gbp_sz | Determines the total memory size allocated by the CF for the group buffer pool for the current database. |
| cf_lock_sz | Determines the total memory size allocated by the CF for the lock structure for the current database. |
| cf_sca_sz | Determines the total memory size allocated by the CF for the shared communication area for the current database. |
The following Db2 database configuration parameters are designated as global database configuration parameters for the Db2 pureScale Feature. For more information about global database configuration parameters see the Configuration parameters that affect the Db2 pureScale Feature topic.
The following Db2 database configuration parameters are designated as per-member database configuration parameters for the Db2 pureScale Feature. For more information about per-member database configuration parameters see the Configuration parameters that affect the Db2 pureScale Feature topic.