IBM Support

How do you confirm if db2 registry variable takes effect immediately or requires db2 instance recycle?

Technical Blog Post


Abstract

How do you confirm if db2 registry variable takes effect immediately or requires db2 instance recycle?

Body

Sometimes we get confused if particular db2 registry variable takes effect immediately or requires db2 instance recycle. So here is the quick command that you can run:


db2set -info <db2_registry_variable_name>

 

Example: 
$ db2set -info DB2_REDUCED_OPTIMIZATION
   Immediate change supported : YES 
   Immediate by default :       NO 
   
Please note '-info' option with db2set is available since db2 v10.1 onwards. In fact, we started supporting '-immediate' option since v10.1 itself.
When immediate change is supported for particular variable, it must need to be set with '-im' option when immediate by default is 'NO'.

 

Example:

$ db2set -im DB2_REDUCED_OPTIMIZATION=YES
This command returns nothing for successful execution.

 

Regards,

Yogesh.

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":""}]

UID

ibm13286275