Results 1 to 5 of 5

Thread: Generic Schema

  1. #1
    Join Date
    Feb 2002
    Location
    Hamilton
    Posts
    150

    Unanswered: Generic Schema

    We have a requirement to failover/failback between two sites a database that has in flight transactions so that we can do maintenance on one site and not totatlly stop access.

    We would like to not have to script a redirected restore from one instance to another (ids are ida and idb for site delineation). So we would like to create the database and have it populated using generic schema so that we can easily export/import the data across sites and databases.

    Is this possible? Has anyone done anything like this before? Or better still does anyone have any better ideas on how to accomplish this?

    thanks in advance

    Platform is AIX 5.1 and DB2 v8 FP2

    Mark

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Mark,
    Have you looked into Replication?

    Andy

  3. #3
    Join Date
    Feb 2002
    Location
    Hamilton
    Posts
    150
    Andy

    No we have not looked into Replication, what would it take to do this sort of thing?

    Mark

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Mark,
    Replication will automatically copy data from one server to the other. There are serveral scenarios that can be set up. To learn more, look in the Replication Guide and Reference manual and there is a Redbook "A Practical Guide to DB2 UDB Data Replication V8". Both are good sources.

    THe redbook can be located at:
    http://publib-b.boulder.ibm.com/Redb...=0,replication

    Andy

    Originally posted by mark_maz
    Andy

    No we have not looked into Replication, what would it take to do this sort of thing?

    Mark

  5. #5
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    You may need Update Anywhere Replication set up ...

    In your scenario, ideally there will be changes to only one side at any given point of time, but that needs to go to the other end ... Hence, you may find this set up easier to manage than two independent captures and subscription definitions

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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