Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2009
    Location
    Calgary, AB Canada
    Posts
    38

    Unanswered: Does HADR preserve (transfer over) db cfg parms?

    I'm wondering if in a HADR cluster, if you change a db cfg parm, will that change propagate over to the standby db?

    I'm testing this out right now, and I'm not seeing that capability, which would cause the databases to be out of sync configuration-wise, and quite possibly break down during a failover.

    The parameters I'm trying to test with is the TRACKMOD, which needs to be turned on for INCREMENTAL DELTA backups.

    Any thoughts?

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    The only db configs that get replicated that I know about are when you first establish the HADR pair when you restore the backup from the primary on to the standby server. Maybe there are some I don't know about, but they would have to show up in the DB2 transaction log.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Oct 2009
    Location
    Calgary, AB Canada
    Posts
    38
    Right exactly.....once the HADR pair is established, do the db cfg parms enter the transaction logs and shipped over?

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Please check this URL:
    IBM DB2 9.5 Information Center for Linux, UNIX, and Windows

    "Non-logged operations, such as changes to database configuration parameters and to the recovery history file, are not replicated to the standby database."

Posting Permissions

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