Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2008
    Location
    Chennai
    Posts
    111

    Unanswered: db2 hadr - create new table space/table/import

    Hello,
    DB2 V8 FP 12 /WINDOWS 2003.

    We have setup the HADR between Primary and the Standby and functioning perfectly.
    Now I am planning to create a new table space and move one of the tables from existing table space to the New table space.
    I am planning to use the export/import to move the data cross.

    The question is, will this changes will be replicate to my standby server?
    or I have to resetup the HADR from the Primary database backup from the begining.
    Please advise me.

    Thanks, dgunas.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Export and import will work, because import basically does inserts that are logged and replayed on the standby. Be sure to use a reasonable COMMITCOUNT parameter value for the import.

    You can also do a load under certain limited circumstances, but check out this link for details on how to do that:
    DB2 Database for Linux, UNIX, and Windows
    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
    Dec 2008
    Location
    Chennai
    Posts
    111

    Thanks

    Thanks Marcus. Really helpfull.

Posting Permissions

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