These
environment variables are specific
to a DB2® pureScale® environment: DB2_DATABASE_CF_MEMORY, DB2_MCR_RECOVERY_PARALLELISM_CAP, DB2_SD_ALLOW_SLOW_NETWORK.
- DB2_DATABASE_CF_MEMORY
-
- Operating system: All
- Default: 100,
Values: -1, or 0 to 100,
or AUTO
- Type: Float
- When DB2_DATABASE_CF_MEMORY is
set to AUTO, CF memory is self-tuned for all databases
that have these database configuration parameters set to AUTOMATIC: cf_gbp_sz, cf_lock_sz,
and cf_sca_sz. DB2_DATABASE_CF_MEMORY can
be changed dynamically, and a database manager restart is not required.
- DB2_DATABASE_CF_MEMORY is used to indicate
the proportion of total CF memory
(CF_MEM_SZ) assigned to each database that has
database configuration parameter cf_db_mem_sz set
to AUTOMATIC. Any database that has cf_db_mem_sz set
to a specific value ignores 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 more information, see DB2 pureScale CF memory
parameter configuration.
- DB2_MCR_RECOVERY_PARALLELISM_CAP
-
- Operating system: All
- In a multiple database environment, if member crash recovery (MCR)
is required, the number of databases 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.
- DB2_SD_ALLOW_SLOW_NETWORK
- Operating system: All
- Default: OFF, Values: ON, OFF
- This
variable allows an Ethernet card that is less than 10GE to use the TCP option
of the cf_transport_method configuration parameter.
- This
lower transfer rate Ethernet card limits performance.
DB2 10.5 for Linux, UNIX, and Windows