DB2 10.5 for Linux, UNIX, and Windows

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.