Changes to database configuration parameters

Db2 version 11.1 contains a number of new and changed database configuration parameters.

Review the changes to learn which ones might affect your existing applications and to determine whether they require adjusting.

Also, review the list of deprecated and discontinued database configuration parameters to learn about additional changes that might also affect your applications and scripts.

Details

Changed database configuration parameters

The following database configuration parameters have changed behaviors, new ranges, or new values in version 11.1.

Table 1. Database configuration parameters with changed behaviors, new ranges, or new values.
Parameter Name	Details
APPLHEAPSZ- Application heap size configuration parameter	The range of APPLHEAPSZ has been extended on 64-bit instances in the range 16 – 2 147 483 647. APPLHEAPSZ has also changed from a `Uint16` type to a `Uint64` type.
CATALOGCACHE_SZ - Catalog cache size configuration parameter	The range of CATALOGCACHE_SZ has been extended on 64-bit instances in the range 8 - 2 147 483 647.
dbheap- Database heap configuration parameter	The range of dbheap has been extended on both 32-bit and 64-bit instances in the range 32 – 2 147 483 647.
rec_his_retentn- Recovery history retention period configuration parameter	rec_his_retentn can now be configured online.
stat_heap_sz - Statistics heap size configuration parameter	The range of stat_heap_sz has been extended on 64-bit instances in the range 1 096 – 2 147 483 647.
stmtheap- Statement heap size configuration parameter	The range of stmtheap has been extended on 64-bit instances in the range 128 – 2 147 483 647.
nchar_mapping - National character mapping configuration parameter	The default for nchar_mapping for new databases has been changed from `GRAPHIC_CU16` to `CHAR_CU32`.

Resolution

Take advantage of enhanced functionality or new features by adopting new functionality through the use of new database configuration parameters or new values for existing database configuration parameters.

For new database configuration parameters or changes to existing database configuration parameters that result in Db2 server behavior changes, adjust your existing applications or scripts.