Changes to database configuration parameters in Db2 11.5

Db2 11.5 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.5.

Table 1. Database configuration parameters with changed behaviors, new ranges, or new values.
Parameter Name Details
logprimary - Number of primary log files configuration parameter For recoverable databases, the maximum number of primary and secondary log files combined has been increased from 256 to 8192.
logsecond - Number of secondary log files configuration parameter For recoverable databases, the maximum number of primary and secondary log files combined has been increased from 256 to 8192.
rec_his_retentn-Recovery history retention period configuration parameter The default value for rec_his_retentn for new databases has been changed from 366 to 90 days.

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.