I already have Db2 HADR going. I need to make some LOCKLIST changes on my primary server. Is there a "preferred" way of doing db cfg changes in a HADR env? or just remember to change them on both the servers?
I turned on the SELF_TUNING_MEM to ON and when i do "db2 get db cfg show details", i can see that the Self Tuning Memory is active, but is it really active if the bufferpools are not set to automatic? I have all the other db config set to automatic.
Bufferpools don't need to tuned by STMM for self_tuning_mem to be active. It's active if there are two or more memory consumers enabled for tuning. STMM doesn't tune all parameters that are set to automatic. It can only tune the ones listed here: IBM DB2 9.5 Information Center for Linux, UNIX, and Windows