How to check whether a Db2 Registry Variable is Immediate or Not

Often you might need to know if a Db2 registry variable can be changed online and immediate, without requiring a Db2 instance restart. This can be done by using the -info option of the db2set command. See the example below, you should add this bit of info to your Db2 toolbox.

Example:

C:\Program Files\IBM\SQLLIB_01\BIN>db2set -info db2_capture_locktimeout
Immediate change supported : YES
Immediate by default : YES

C:\Program Files\IBM\SQLLIB_01\BIN>db2set -info db2_use_alternate_page_cleaning
Immediate change supported : NO
Immediate by default : NO