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.
UID
ibm13286275