Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2008
    Posts
    96

    Unanswered: 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

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    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

  3. #3
    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.

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •