DB2 registry change

[Former Member]

Hello experts,

is there any chance to find out which registry changes can be changed without a restart for activation? I have to change DB2_BCKP_PAGE_VERIFICATION=TRUE but unhappy with any downtime.

Regards

Olaf

[Frank-Martin · Accepted solution]

Hi Olaf,

for this registry variable the behavior is not clearly documentged but it  should work.

>db2set DB2_BCKP_PAGE_VERIFICATION=YES -immediate

returns no error.

For other variables that are not changable online you receie an error when using the -immediate option. For example:

>db2set DB2_CREATE_DB_ON_PATH=YES -immediate

DBI1439W
The option -immediate was used when running db2set, but the variable specified cannot be updated immediately

Regards

                 Frank

More information:

http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.1.0/com.ibm.db2.luw.admin.cmd.doc/doc/r00020...

Sets the specified variable to the specified value. If the value has space(s), make sure to
enclose the value in quotes. If you do not specify a value after the equal sign
(=), the current value of the variable is deleted. There are a set of registry
variables which are immediate by default and another set of registry variables
that are immediate if you specify the -immediateparameter. Both of these sets of
registry variables take effect the next time the SQL statement is compiled.
Otherwise, changes take effect after you restart the instance

http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.1.0/com.ibm.db2.luw.admin.regvars.doc/doc/r0...

DB2_ATS_ENABLE

• Operating
  system: All
• Default: NULL,
  Values: YES/TRUE/ON/1NO/FALSE/OFF/0
• This
  variable controls whether the administrative task scheduler is running. The
  administrative task scheduler is disabled by default. When the scheduler is
  disabled, you can use the built-in procedures and views to define and modify
  tasks but the scheduler will not execute the tasks.
• Changes to
  this variable will take effect immediately for all future compiled SQL
  statements. There is no need to restart the instance or to issue the db2set-immediate.
  
• DB2_BCKP_PAGE_VERIFICATION
  

• Operating
  system: All
• Default: FALSE,
  Values: FALSETRUE
• Specifies
  whether DMS and AS page validation occurs during a backup

For the case of DB2_BCKP_PAGE_VERIFICATION the remark is missing.

[Former Member · Accepted solution]

Hi Olaf,

this works for you:

db2set -info DB2_BCKP_PAGE_VERIFICATION

   Immediate change supported : YES

   Immediate by default :       YES

Best regards

Joachim

[Frank-Martin · Accepted solution]

Thanks. I learned something new ...

[JPReyes]

Hi Olaf,

This is where you take a sandbox and test it... then you can tell for sure.

Regards, Juan

[former_member264034]

Hello Olaf,

For registry settings, normally a restart will be necessary and there is no option but to
stop and restart even when immediate is set.
For this variable see APAR IC89555.

db2set DB2_BCKP_PAGE_VERIFICATION=OFF

db2stop

db2start

db2set - DB2 profile registry command

Regards,
Aidan

[Former Member]

Hello Aidan,

thanks for the answer but it was not my request. 😉 Its well known how to change the parameter but I like to know whether downtime is needed before I discuss with business about a parameter change and a time slot.

When I follow up Baklarz/Zikopoulos than a downtime is not needed for every registry change.

Regards

Olaf