If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Changing db cfg in DB2 HADR env

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 09-22-10, 16:56
rangupt rangupt is offline
Registered User
 
Join Date: Jan 2008
Posts: 96
Changing db cfg in DB2 HADR env

Hi,

ENV: RedHat Linux 5.3, DB2 9.5 FP 5

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?

Thanks
Reply With Quote
  #2 (permalink)  
Old 09-22-10, 18:30
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
I always do:

Quote:
Originally Posted by rangupt View Post
just remember to change them on both the servers
so that the new primary is in sync with the old primary after takeover
Reply With Quote
  #3 (permalink)  
Old 09-23-10, 10:30
rangupt rangupt is offline
Registered User
 
Join Date: Jan 2008
Posts: 96
Thanks Bella.

Another question, a little off topic though.

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.

Thanks again.
Reply With Quote
  #4 (permalink)  
Old 09-23-10, 10:54
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On