cf_sca_sz - Shared communication area configuration parameter
This Shared Communication Area (SCA) configuration parameter determines the memory size used by the SCA in the cluster caching facility (CF). The SCA is a per database entity and contains database wide control block information for tables, indexes, table spaces, and catalogs.
- Configuration type
- Database
- Applies to
- Db2® pureScale® environment
- Parameter type
- Configurable online
- Default [range]
- AUTOMATIC [AUTOMATIC, 2048 - 1073741824]
- Unit of measure
- Pages (4 KB)
- When allocated
- When the database is first activated on any Db2 member
- When freed
- When the database is dropped or when the CF server is stopped
When you set the cf_sca_sz parameter to AUTOMATIC (default), the memory value is computed by the Db2 database manager during the first database activation on any member to a value that is sufficient for basic database operations. If you want to configure the exact memory size for the SCA, you can set the cf_sca_sz parameter to a fixed numeric value.
You can obtain the current value for the SCA size by running the GET DB CFG SHOW DETAIL command. If the cf_sca_sz parameter is set to AUTOMATIC, the SHOW DETAIL clause displays the computed value as well as the allocated value for the SCA.
If the SCA memory is fully consumed by database operations, an out of memory error message is returned. In this case, you can increase the size of the SCA by setting a higher value for the cf_sca_sz parameter.
See Configuring cluster caching facility memory
for a database
for more detail.