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:
- Review the information about new, changed, deprecated,
and discontinued registry variables, and based on the upgrade impact,
choose the appropriate settings:
- Db2 server behavior changes
- Consider removing registry variables that have been deprecated or discontinued in Db2
version 11.5 or earlier releases that can impact the upgrade of your Db2
server:
-
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.
- Review the information about new, changed, and deprecated
database manager configuration parameters, and based on the upgrade
impact, choose the appropriate settings:
- Db2 server behavior changes
- There are no database manager configuration parameters that have been deprecated or discontinued
in this release. However, if you are upgrading from Db2
Version 10.1 or earlier, consider removing database manager configuration parameters that have been
deprecated in pre-Db2
version 11.5 releases:
- Review the information about new, changed, deprecated,
and discontinued database configuration parameters, and based on the
upgrade impact, choose the appropriate settings:
- Db2 server behavior changes
- See What's changed for further details on functionality that has been deprecated or
discontinued in this release. If you are upgrading from Db2
Version 10.1 or earlier, consider removing database manager configuration parameters that have been
deprecated or discontinued in pre-Db2
version 11.5 releases:
- 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.