DB2 Version 10.1 for Linux, UNIX, and Windows

DB2 pureScale environment variables

There are two environment variables that you can set for DB2® pureScale® systems.

DB2_DATABASE_CF_MEMORY
  • Operating system: All
  • Default: 100, Values: -1, or 0 to 100
  • Type: Float
  • This variable is specifically for a DB2 pureScale environment.
  • DB2_DATABASE_CF_MEMORY is used to indicate the proportion of the total CF memory (CF_MEM_SZ) that will be assigned to each database that has the cf_db_mem_sz database configuration parameter set to AUTOMATIC. Any database that has cf_db_mem_sz set to a specific value will ignore this registry variable.
  • For all databases to have an equal share of the CF memory resources when more that 100 databases are active, the DB2_DATABASE_CF_MEMORY registry variable must use values less than 1. For example, if there are 200 active databases, each with an equal share of the CF memory, this registry variable must be set to 0.5.
  • Use of the DB2_DATABASE_CF_MEMORY registry variable must be coordinated with the cf_db_mem_sz and numdb configuration parameters. For additional information, see DB2 pureScale CF memory parameter configuration.
DB2_MCR_RECOVERY_PARALLELISM_CAP
  • Operating system: All
  • This variable is specifically for a DB2 pureScale environment.
  • In a multiple database environment, if member crash recovery (MCR) is required, the number of databases that will be recovered in parallel on each member is set by the value of the numdb configuration parameter or the DB2_MCR_RECOVERY_PARALLELISM_CAP registry variable, whichever value is smaller.