Managing Db2 server behavior changes

The changes in Db2 registry variables, configuration parameters, and database physical design characteristics can have an upgrade impact. Review these changes to manage the upgrade impact.

About this task

After upgrading your Db2 server, compare the values of your registry variables and configuration parameters to their values before upgrade. If you find any differences, take the time to understand them because they could alter the behavior or performance of your applications. However, consider carefully whether to disable any new functionality because it provides support for new resources needed by the database manager. You should disable new functionality only if you experience negative performance or unwanted behavior.

Procedure

To manage Db2 server behavior changes:

  1. Review the information about new, changed, deprecated, and discontinued registry variables, and based on the upgrade impact, choose the appropriate settings:
  2. Set your Db2 global profile registry variables. The variables that you set at the global profile level, using the db2set command with the -g option, are not upgraded. The global profile variables apply to all instances pertaining to a specific Db2 copy. Therefore, after upgrading your instances, use the configuration information that you saved in the pre-upgrade tasks to restore the values of your global profile registry variables for every Db2 version 11.5 copy.
  3. Review the information about new, changed, and deprecated database manager configuration parameters, and based on the upgrade impact, choose the appropriate settings:
  4. Review the information about new, changed, deprecated, and discontinued database configuration parameters, and based on the upgrade impact, choose the appropriate settings:
  5. Review the changes in database physical design characteristics and security, and based on the upgrade impact, modify database objects accordingly:

What to do next

If you change the settings of any database manager configuration parameters that are not dynamic, you might need to restart the instance so the new settings take effect.