Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2008

    Unanswered: HADR - Update database structure howto?

    Hi all,

    We just have a setup of 2 servers with HADR available (and working). We just need to update a database with new fields and triggers.

    How should i perform this? Is't true that when i update the database with some new fields / triggers on the primary server that those changes are automatic replicated to the standby server?

    Anyone some idea's about this?

  2. #2
    Join Date
    May 2003
    Yes, that is correct. The only thing you have to worry about are activities that are not logged by DB2. That includes the following:

    - LOB columns that are created as NOT LOGGED
    - LOB columns over 1 GB in size (DB2 cannot log LOBs over 1 GB)
    - Load utility (import is OK). There are certain cases when a Load is OK, but I am not going to explain that here.

    The other thing to be careful about is to make sure your tablespace container names are identical on each server. That means your mount points, drives, directories, etc where the data is stored must be the same on each server. That way you extend tablespace containers, etc without a problem.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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