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

Mark,
Have you looked into Replication?

Andy

Andy

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

Mark

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

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